[COMMITTERS] pgsql-server/src/bin/pg_dump pg_dump_sort.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/06 18:55:11 Modified files: src/bin/pg_dump: pg_dump_sort.c Log message: Replace not-very-bright implementation of topological sort with a better one (use a priority heap to keep track of items ready to output, instead of searching the input array each time). This brings the runtime of pg_dump back to about what it was in 7.4. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[COMMITTERS] pgsql-server/doc/src/sgml catalogs.sgml runtim ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/06 19:10:24 Modified files: doc/src/sgml : catalogs.sgml runtime.sgml Log message: Documentation update for previously committed changes: read-only GUC variables and pg_settings view. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql-server/doc TODO
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/06 20:54:05 Modified files: doc: TODO Log message: Done: > * -Use dependency information to dump data in proper order ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [COMMITTERS] pgsql-server/ oc/src/sgml/ref/pg_restore.sgml ...
TODO updated: * -Use dependency information to dump data in proper order --- Tom Lane wrote: > CVSROOT: /cvsroot > Module name: pgsql-server > Changes by: [EMAIL PROTECTED] 03/12/05 23:00:16 > > Modified files: > doc/src/sgml/ref: pg_restore.sgml > src/bin/pg_dump: Makefile common.c pg_backup.h >pg_backup_archiver.c pg_backup_archiver.h >pg_backup_custom.c pg_backup_files.c >pg_backup_null.c pg_backup_tar.c pg_dump.c >pg_dump.h pg_restore.c > Added files: > src/bin/pg_dump: pg_dump_sort.c > > Log message: > Massive overhaul of pg_dump: make use of dependency information from > pg_depend to determine a safe dump order. Defaults and check constraints > can be emitted either as part of a table or domain definition, or > separately if that's needed to break a dependency loop. Lots of old > half-baked code for controlling dump order removed. > > > ---(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src/bin/pg_dump common.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/06 23:14:01 Modified files: src/bin/pg_dump: common.c Log message: Speed up findObjectByCatalogId() to get rid of the other salient bottleneck in the new pg_dump code. ---(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-server/src/backend/utils/adt Tag: REL7_3 ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/07 00:11:26 Modified files: src/backend/utils/adt: Tag: REL7_3_STABLE selfuncs.c Log message: Repair indexed bytea like operations, and related selectivity functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php ---(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-server/src/backend/utils/adt selfuncs.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/07 00:14:11 Modified files: src/backend/utils/adt: selfuncs.c Log message: Repair indexed bytea like operations, and related selectivity functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php ---(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-server/src/backend/utils/adt Tag: REL7_4 ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/07 00:12:50 Modified files: src/backend/utils/adt: Tag: REL7_4_STABLE selfuncs.c Log message: Repair indexed bytea like operations, and related selectivity functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [COMMITTERS] pgsql-server/src/backend/utils/adt Tag: REL7_3 ...
[EMAIL PROTECTED] (Joe Conway) writes: > Repair indexed bytea like operations, and related selectivity > functionality. Would this be a useful thing to write some regression tests for? -Neil ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql-server/src/bin/pg_dump pg_dump_sort.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/07 01:44:50 Modified files: src/bin/pg_dump: pg_dump_sort.c Log message: One more pass at reducing the cost of pg_dump's new implementation: reduce the number of times TopoSort() has to be executed by trying to extract multiple dependency loops from each pass, instead of only one. This saves about another factor of ten on the regression database. This could be considered as another exercise in grokking Fred Brooks' maxim: Representation *is* the essence of programming. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [COMMITTERS] pgsql-server/src/backend/utils/adt Tag: REL7_3 ...
Neil Conway wrote: [EMAIL PROTECTED] (Joe Conway) writes: Repair indexed bytea like operations, and related selectivity functionality. Would this be a useful thing to write some regression tests for? I thought about it, but this was not really a regression so much as it was poor testing on my part before the feature was added in the first place. I guess I could easily enough add the test cases I've been using though. Joe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
