[COMMITTERS] pgsql: Replace the BufMgrLock with separate locks on the lookup
Log Message: --- Replace the BufMgrLock with separate locks on the lookup hashtable and the freelist, plus per-buffer spinlocks that protect access to individual shared buffer headers. This requires abandoning a global freelist (since the freelist is a global contention point), which shoots down ARC and 2Q as well as plain LRU management. Adopt a clock sweep algorithm instead. Preliminary results show substantial improvement in multi-backend situations. Modified Files: -- pgsql/doc/src/sgml: runtime.sgml (r1.306 -> r1.307) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/runtime.sgml.diff?r1=1.306&r2=1.307) pgsql/src/backend/catalog: index.c (r1.244 -> r1.245) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/index.c.diff?r1=1.244&r2=1.245) pgsql/src/backend/commands: dbcommands.c (r1.151 -> r1.152) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.151&r2=1.152) vacuum.c (r1.302 -> r1.303) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c.diff?r1=1.302&r2=1.303) pgsql/src/backend/postmaster: bgwriter.c (r1.14 -> r1.15) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/bgwriter.c.diff?r1=1.14&r2=1.15) pgsql/src/backend/storage/buffer: README (r1.7 -> r1.8) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/README.diff?r1=1.7&r2=1.8) buf_init.c (r1.71 -> r1.72) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/buf_init.c.diff?r1=1.71&r2=1.72) buf_table.c (r1.39 -> r1.40) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/buf_table.c.diff?r1=1.39&r2=1.40) bufmgr.c (r1.185 -> r1.186) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/bufmgr.c.diff?r1=1.185&r2=1.186) freelist.c (r1.50 -> r1.51) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/freelist.c.diff?r1=1.50&r2=1.51) localbuf.c (r1.62 -> r1.63) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/localbuf.c.diff?r1=1.62&r2=1.63) pgsql/src/backend/utils/misc: guc.c (r1.253 -> r1.254) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c.diff?r1=1.253&r2=1.254) postgresql.conf.sample (r1.134 -> r1.135) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample.diff?r1=1.134&r2=1.135) pgsql/src/backend/utils/resowner: resowner.c (r1.9 -> r1.10) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/resowner/resowner.c.diff?r1=1.9&r2=1.10) pgsql/src/include/postmaster: bgwriter.h (r1.4 -> r1.5) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/postmaster/bgwriter.h.diff?r1=1.4&r2=1.5) pgsql/src/include/storage: buf_internals.h (r1.76 -> r1.77) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/buf_internals.h.diff?r1=1.76&r2=1.77) bufmgr.h (r1.89 -> r1.90) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/bufmgr.h.diff?r1=1.89&r2=1.90) lwlock.h (r1.16 -> r1.17) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/lwlock.h.diff?r1=1.16&r2=1.17) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgbuildfarm - client-code: force a build if we don't have a snapshot
Log Message: --- force a build if we don't have a snapshot time for the last run - otherwise we might never do a build at all - change should force at most one build per branch ever. Modified Files: -- client-code: run_build.pl (r1.21 -> r1.22) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbuildfarm/client-code/run_build.pl.diff?r1=1.21&r2=1.22) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: Imported Sources
Update of /cvsroot/pgswish/pgswish In directory pgfoundry.org:/tmp/cvs-serv93913 Log Message: new CVS module Status: Vendor Tag: svn2cvs Release Tags: r0 N pgswish/.svnrev No conflicts created by this import ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: first semi-working version (properties and sort
Log Message: --- first semi-working version (properties and sort doesn't work) Added Files: --- pgswish: Makefile (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: first semi-working version (properties and sort
Log Message: --- first semi-working version (properties and sort doesn't work) Added Files: --- pgswish: test.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgswish - pgswish: first semi-working version (properties and sort
Log Message: --- first semi-working version (properties and sort doesn't work) Added Files: --- pgswish: pgswish.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgswish - pgswish: subversion revision 1 commited to CVS
Log Message: --- subversion revision 1 commited to CVS Modified Files: -- pgswish: .svnrev (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.1.1.1&r2=1.2) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgswish - pgswish: Imported Sources
Update of /cvsroot/pgswish/pgswish/patch In directory pgfoundry.org:/tmp/cvs-serv95151 Log Message: patch to compile DBD::PgSPI on Debian Status: Vendor Tag: svn Release Tags: r2 N pgswish/patch/DBD-PgSPI-0.02-Debian_fix.diff No conflicts created by this import ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: subversion revision 2 commited to CVS
Log Message: --- subversion revision 2 commited to CVS Modified Files: -- pgswish: .svnrev (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.2&r2=1.3) ---(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] pgswish - pgswish: work from current directory
Log Message: --- work from current directory Modified Files: -- pgswish: Makefile (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgswish - pgswish: work from current directory
Log Message: --- work from current directory Modified Files: -- pgswish: test.sql (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgswish - pgswish: subversion revision 3 commited to CVS
Log Message: --- subversion revision 3 commited to CVS Modified Files: -- pgswish: .svnrev (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.3&r2=1.4) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgswish - pgswish: cleanup
Log Message: --- cleanup Modified Files: -- pgswish: Makefile (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile.diff?r1=1.2&r2=1.3) ---(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] pgswish - pgswish: fix
Log Message: --- fix Modified Files: -- pgswish: test.sql (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql.diff?r1=1.2&r2=1.3) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: subversion revision 5 commited to CVS
Log Message: --- subversion revision 5 commited to CVS Modified Files: -- pgswish: .svnrev (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.5&r2=1.6) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: Imported Sources
Update of /cvsroot/pgswish/pgswish/perl In directory pgfoundry.org:/tmp/cvs-serv96050 Log Message: directory for proof-of-concept perl implementation Status: Vendor Tag: svn Release Tags: r6 No conflicts created by this import ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgswish - pgswish: subversion revision 6 commited to CVS
Log Message: --- subversion revision 6 commited to CVS Modified Files: -- pgswish: .svnrev (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.6&r2=1.7) ---(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] pgswish - pgswish: Imported Sources
Update of /cvsroot/pgswish/pgswish/patch In directory pgfoundry.org:/tmp/cvs-serv95725 Log Message: patch to compile DBD::PgSPI on Debian Status: Vendor Tag: svn Release Tags: r2 U pgswish/patch/DBD-PgSPI-0.02-Debian_fix.diff No conflicts created by this import ---(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] pgswish - pgswish: perl proof-of-concept implementation moved to perl
Log Message: --- perl proof-of-concept implementation moved to perl directory Removed Files: - pgswish: test.sql (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql) ---(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] pgswish - pgswish: perl proof-of-concept implementation moved to perl
Log Message: --- perl proof-of-concept implementation moved to perl directory Added Files: --- pgswish/perl: Makefile (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/perl/Makefile?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: perl proof-of-concept implementation moved to perl
Log Message: --- perl proof-of-concept implementation moved to perl directory Added Files: --- pgswish/perl: README (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/perl/README?rev=1.1&content-type=text/x-cvsweb-markup) ---(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] pgswish - pgswish: perl proof-of-concept implementation moved to perl
Log Message: --- perl proof-of-concept implementation moved to perl directory Added Files: --- pgswish/perl: pgswish.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/perl/pgswish.sql?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] pgswish - pgswish: subversion revision 7 commited to CVS
Log Message: --- subversion revision 7 commited to CVS Modified Files: -- pgswish: .svnrev (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.7&r2=1.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] pgswish - pgswish: subversion revision 4 commited to CVS
Log Message: --- subversion revision 4 commited to CVS Modified Files: -- pgswish: .svnrev (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.4&r2=1.5) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgswish - pgswish: perl proof-of-concept implementation moved to perl
Log Message: --- perl proof-of-concept implementation moved to perl directory Removed Files: - pgswish: Makefile (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgswish - pgswish: first, not-yet working C version
Log Message: --- first, not-yet working C version Added Files: --- pgswish: pgswish.c (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c?rev=1.1&content-type=text/x-cvsweb-markup) ---(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] pgswish - pgswish: lot of implementation fixes
Log Message: --- lot of implementation fixes Modified Files: -- pgswish: Makefile (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile.diff?r1=1.5&r2=1.6) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: lot of implementation fixes
Log Message: --- lot of implementation fixes Modified Files: -- pgswish: pgswish.sql (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql.diff?r1=1.3&r2=1.4) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: lot of implementation fixes
Log Message: --- lot of implementation fixes Modified Files: -- pgswish: pgswish.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.1&r2=1.2) ---(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] pgswish - pgswish: perl proof-of-concept implementation moved to perl
Log Message: --- perl proof-of-concept implementation moved to perl directory Removed Files: - pgswish: pgswish.sql (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgswish - pgswish: first, not-yet working C version
Log Message: --- first, not-yet working C version Added Files: --- pgswish: Makefile (r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile?rev=1.5&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgswish - pgswish: perl proof-of-concept implementation moved to perl
Log Message: --- perl proof-of-concept implementation moved to perl directory Added Files: --- pgswish/perl: test.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/perl/test.sql?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgswish - pgswish: subversion revision 8 commited to CVS
Log Message: --- subversion revision 8 commited to CVS Modified Files: -- pgswish: .svnrev (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.8&r2=1.9) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: subversion revision 9 commited to CVS
Log Message: --- subversion revision 9 commited to CVS Modified Files: -- pgswish: .svnrev (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.9&r2=1.10) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgswish - pgswish: first, not-yet working C version
Log Message: --- first, not-yet working C version Added Files: --- pgswish: pgswish.sql (r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql?rev=1.3&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: subversion revision 10 commited to CVS
Log Message: --- subversion revision 10 commited to CVS Modified Files: -- pgswish: .svnrev (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.10&r2=1.11) ---(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] pgswish - pgswish: subversion revision 11 commited to CVS
Log Message: --- subversion revision 11 commited to CVS Modified Files: -- pgswish: .svnrev (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.11&r2=1.12) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: first working version (without returning properties)
Log Message: --- first working version (without returning properties) Modified Files: -- pgswish: Makefile (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile.diff?r1=1.6&r2=1.7) pgswish.sql (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql.diff?r1=1.5&r2=1.6) pgswish.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.5&r2=1.6) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgswish - pgswish: subversion revision 14 commited to CVS
Log Message: --- subversion revision 14 commited to CVS Modified Files: -- pgswish: .svnrev (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.14&r2=1.15) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgswish - pgswish: subversion revision 13 commited to CVS
Log Message: --- subversion revision 13 commited to CVS Modified Files: -- pgswish: .svnrev (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.13&r2=1.14) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgswish - pgswish: subversion revision 16 commited to CVS
Log Message: --- subversion revision 16 commited to CVS Modified Files: -- pgswish: .svnrev (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.16&r2=1.17) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgswish - pgswish: elog less
Log Message: --- elog less Modified Files: -- pgswish: pgswish.c (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.8&r2=1.9) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgswish - pgswish: subversion revision 17 commited to CVS
Log Message: --- subversion revision 17 commited to CVS Modified Files: -- pgswish: .svnrev (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.17&r2=1.18) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgswish - pgswish: more cleanup
Log Message: --- more cleanup Modified Files: -- pgswish: test.sql (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql.diff?r1=1.7&r2=1.8) pgswish.c (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.9&r2=1.10) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgswish - pgswish: on, I mixed SWISH_RESULTS and SW_RESULT...
Log Message: --- on, I mixed SWISH_RESULTS and SW_RESULT... Modified Files: -- pgswish: pgswish.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.3&r2=1.4) ---(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] pgswish - pgswish: found why back-end crash (swish-e need aditional
Log Message: --- found why back-end crash (swish-e need aditional parametar for this ranking scheme) Modified Files: -- pgswish: pgswish.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.2&r2=1.3) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: allmost work, but not yet
Log Message: --- allmost work, but not yet Modified Files: -- pgswish: pgswish.sql (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql.diff?r1=1.4&r2=1.5) pgswish.c (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.4&r2=1.5) ---(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] pgswish - pgswish: subversion revision 12 commited to CVS
Log Message: --- subversion revision 12 commited to CVS Modified Files: -- pgswish: .svnrev (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.12&r2=1.13) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: cleanup log levels, a try to implement properties as
Log Message: --- cleanup log levels, a try to implement properties as another function (won't work) Modified Files: -- pgswish: Makefile (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/Makefile.diff?r1=1.7&r2=1.8) pgswish.sql (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql.diff?r1=1.6&r2=1.7) pgswish.c (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.6&r2=1.7) Added Files: --- pgswish: test.sql (r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql?rev=1.5&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: fixed tests to work
Log Message: --- fixed tests to work Modified Files: -- pgswish: test.sql (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql.diff?r1=1.5&r2=1.6) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgswish - pgswish: subversion revision 15 commited to CVS
Log Message: --- subversion revision 15 commited to CVS Modified Files: -- pgswish: .svnrev (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.15&r2=1.16) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgswish - pgswish: a try to implement function which returns record
Log Message: --- a try to implement function which returns record (pgswish2) Modified Files: -- pgswish: test.sql (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/test.sql.diff?r1=1.6&r2=1.7) pgswish.sql (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.sql.diff?r1=1.7&r2=1.8) pgswish.c (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/pgswish.c.diff?r1=1.7&r2=1.8) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgswish - pgswish: subversion revision 18 commited to CVS
Log Message: --- subversion revision 18 commited to CVS Modified Files: -- pgswish: .svnrev (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgswish/pgswish/.svnrev.diff?r1=1.18&r2=1.19) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
