[COMMITTERS] pgsql: Minor performance improvement: avoid unnecessary
Log Message: --- Minor performance improvement: avoid unnecessary creation/unioning of bitmaps for multiple indexscans. Instead just let each indexscan add TIDs directly into the BitmapOr node's result bitmap. Modified Files: -- pgsql/src/backend/executor: nodeBitmapAnd.c (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeBitmapAnd.c.diff?r1=1.1&r2=1.2) nodeBitmapIndexscan.c (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeBitmapIndexscan.c.diff?r1=1.1&r2=1.2) nodeBitmapOr.c (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeBitmapOr.c.diff?r1=1.1&r2=1.2) pgsql/src/include/nodes: execnodes.h (r1.126 -> r1.127) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h.diff?r1=1.126&r2=1.127) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] oledb - oledb: Remove extra zealous assert
Log Message: --- Remove extra zealous assert Modified Files: -- oledb: PgRS.cpp (r1.37 -> r1.38) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/PgRS.cpp.diff?r1=1.37&r2=1.38) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql: Fix mis-display of negative fractional seconds in interval values
Log Message: --- Fix mis-display of negative fractional seconds in interval values for --enable-integer-datetimes case. Per report from Oliver Siegmar. Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.138 -> r1.139) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.138&r2=1.139) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql: Fix mis-display of negative fractional seconds in interval values
Log Message: --- Fix mis-display of negative fractional seconds in interval values for --enable-integer-datetimes case. Per report from Oliver Siegmar. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.137 -> r1.137.4.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.137&r2=1.137.4.1) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgsql: Fix mis-display of negative fractional seconds in interval values
Log Message: --- Fix mis-display of negative fractional seconds in interval values for --enable-integer-datetimes case. Per report from Oliver Siegmar. Tags: REL7_4_STABLE Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.118.2.4 -> r1.118.2.5) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.118.2.4&r2=1.118.2.5) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgsql: Fix mis-display of negative fractional seconds in interval values
Log Message: --- Fix mis-display of negative fractional seconds in interval values for --enable-integer-datetimes case. Per report from Oliver Siegmar. Tags: REL7_3_STABLE Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.96.2.7 -> r1.96.2.8) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.96.2.7&r2=1.96.2.8) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] oledb - oledb: Support functions for quoting identifiers and strings
Log Message: --- Support functions for quoting identifiers and strings Modified Files: -- oledb: PgDS.h (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/PgDS.h.diff?r1=1.6&r2=1.7) PgDs.cpp (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/PgDs.cpp.diff?r1=1.4&r2=1.5) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql: Don't try to run clauseless index scans on index types that don't
Log Message: --- Don't try to run clauseless index scans on index types that don't support it. Per report from Marinos Yannikos. Modified Files: -- pgsql/src/backend/optimizer/path: indxpath.c (r1.173 -> r1.174) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.173&r2=1.174) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgsql: Don't try to run clauseless index scans on index types that don't
Log Message: --- Don't try to run clauseless index scans on index types that don't support it. Per report from Marinos Yannikos. Tags: REL7_4_STABLE Modified Files: -- pgsql/src/backend/optimizer/path: indxpath.c (r1.147 -> r1.147.4.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.147&r2=1.147.4.1) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql: Don't try to run clauseless index scans on index types that don't
Log Message: --- Don't try to run clauseless index scans on index types that don't support it. Per report from Marinos Yannikos. Tags: REL7_3_STABLE Modified Files: -- pgsql/src/backend/optimizer/path: indxpath.c (r1.124.2.1 -> r1.124.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.124.2.1&r2=1.124.2.2) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql: Don't try to run clauseless index scans on index types that don't
Log Message: --- Don't try to run clauseless index scans on index types that don't support it. Per report from Marinos Yannikos. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/optimizer/path: indxpath.c (r1.167.4.1 -> r1.167.4.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.167.4.1&r2=1.167.4.2) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] oledb - oledb: Finally found out how to test "OpenRowset".
Log Message: --- Finally found out how to test "OpenRowset". Fixed implementation. Modified Files: -- oledb: PgDs.cpp (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/PgDs.cpp.diff?r1=1.5&r2=1.6) PgSess.cpp (r1.33 -> r1.34) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/PgSess.cpp.diff?r1=1.33&r2=1.34) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql: Don't try to run clauseless index scans on index types that don't
Log Message: --- Don't try to run clauseless index scans on index types that don't support it. Per report from Marinos Yannikos. Tags: REL7_2_STABLE Modified Files: -- pgsql/src/backend/optimizer/path: indxpath.c (r1.112.2.1 -> r1.112.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.112.2.1&r2=1.112.2.2) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] pgsql: Add note clarifying that indexes that support ordered scans had
Log Message: --- Add note clarifying that indexes that support ordered scans had better allow clauseless scans. Modified Files: -- pgsql/doc/src/sgml: indexam.sgml (r2.3 -> r2.4) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/indexam.sgml.diff?r1=2.3&r2=2.4) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgsql: Make pg_ctl status do a kill() test to verify that the PID found
Log Message: --- Make pg_ctl status do a kill() test to verify that the PID found in postmaster.pid still represents a live postmaster. Modified Files: -- pgsql/src/bin/pg_ctl: pg_ctl.c (r1.55 -> r1.56) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_ctl/pg_ctl.c.diff?r1=1.55&r2=1.56) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql: Make pg_ctl status do a kill() test to verify that the PID found
Log Message: --- Make pg_ctl status do a kill() test to verify that the PID found in postmaster.pid still represents a live postmaster. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/bin/pg_ctl: pg_ctl.c (r1.53 -> r1.53.4.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_ctl/pg_ctl.c.diff?r1=1.53&r2=1.53.4.1) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql: Install some slightly realistic cost estimation for bitmap index
Log Message: --- Install some slightly realistic cost estimation for bitmap index scans. Modified Files: -- pgsql/src/backend/nodes: outfuncs.c (r1.247 -> r1.248) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/outfuncs.c.diff?r1=1.247&r2=1.248) pgsql/src/backend/optimizer/path: costsize.c (r1.142 -> r1.143) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c.diff?r1=1.142&r2=1.143) indxpath.c (r1.174 -> r1.175) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.174&r2=1.175) orindxpath.c (r1.67 -> r1.68) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/orindxpath.c.diff?r1=1.67&r2=1.68) pgsql/src/backend/optimizer/plan: createplan.c (r1.180 -> r1.181) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/createplan.c.diff?r1=1.180&r2=1.181) pgsql/src/backend/optimizer/util: pathnode.c (r1.116 -> r1.117) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/pathnode.c.diff?r1=1.116&r2=1.117) pgsql/src/include/nodes: relation.h (r1.105 -> r1.106) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/relation.h.diff?r1=1.105&r2=1.106) pgsql/src/include/optimizer: cost.h (r1.64 -> r1.65) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/cost.h.diff?r1=1.64&r2=1.65) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgsql: Done: < * Add tool to query pg_stat_* tables and report indexes
Log Message: --- Done: < * Add tool to query pg_stat_* tables and report indexes that aren't needed < or tables that might need indexes Modified Files: -- pgsql/doc: TODO (r1.1500 -> r1.1501) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1500&r2=1.1501) pgsql/doc/src/FAQ: TODO.html (r1.7 -> r1.8) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.7&r2=1.8) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
