PgSql

[HACKERS] pg_restore --single-transaction and --clean
As another glitch in pg_restore, a combination of options --single-transaction and --clean raises errors if we restore data into an empty database. The reason is pg_restore uses DROP <OBJECT>. The cleanup command fails if the target object doesn't exist. Is it a TODO item to replace "DROP" into "DROP IF EXISTS" ... 10 Feb 2010 00:08

[HACKERS] psql tab-completion for new syntax
We've added some new syntax in HEAD, but psql tab-completion is out of sync. Here is a patch to support the following syntax in tab-completion: - top-level DO - ALTER TABLE/INDEX/TABLESPACE SET/RESET with options - ALTER TABLE ALTER COLUMN SET/RESET with options - CREATE TRIGGER with events Th... 9 Feb 2010 21:56

[HACKERS] log_error_verbosity placement
I just realized that log_error_verbosity is in the wrong section in postgresql.conf and in our manual. It is listed under "When to log" when in fact it should be in the "What to log" section. I also added documentation of what "terse" mode actually does. I added "verbosity" information a few weeks ago. Patch... 9 Feb 2010 18:34

[HACKERS] Some belated patch review for "Buffers" explain analyze patch
I was recently experimenting with explain analyze and I realized there are two things arguably wrong with the "Buffers" output in explain analyze: Firstly, it's printing out a number of buffers. We spent a lot of effort making all GUC variables use units of memory like "kB" and "MB" so the user should never have... 9 Feb 2010 15:08

I: [HACKERS] About "Our CLUSTER implementation is pessimal" patch
On Tue, Feb 9, 2010 at 5:49 AM, Leonardo F <m_lists(a)yahoo.it> wrote: Not even a comment? As I said, performance results on my system were very good.... Hi Leonardo, Perhaps you could supply a .sql file containing a testcase illustrating the performance benefits you tested with your patch -- as I underst... 10 Feb 2010 08:52

[HACKERS] Why doesn't smgr_redo truncate the VM fork too?
Seems inconsistent ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ... 9 Feb 2010 15:08

bugfix - VIP: variadic function ignore strict flag
2010/2/9 Tom Lane <tgl(a)sss.pgh.pa.us>: Pavel Stehule <pavel.stehule(a)gmail.com> writes: 2010/2/9 Tom Lane <tgl(a)sss.pgh.pa.us>: I don't think this is right at all. yes, this isn't clear. My arguments for change: a) the behave depends on types - "any" is different than others. So what?  "v... 9 Feb 2010 16:17

TCP keepalive support for libpq
On Tue, Feb 9, 2010 at 14:03, Tollef Fog Heen <tollef.fog.heen(a)collabora.co.uk> wrote: (please Cc me on replies, I am not subscribed) Hi, libpq currently does not use TCP keepalives.  This is a problem in our case where we have some clients waiting for notifies and then the connection is droppe... 15 Feb 2010 20:01

set the cost of an aggregate function
On Thu, Dec 3, 2009 at 7:19 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: The answer is nobody got round to enhancing this yet and well considered proposals and subsequent patches would be welcome. what is a well considered proposal in this area? the transition function cost should be applied to every ... 8 Feb 2010 23:40

[HACKERS] CVS checkout source code for different branches
Hi, I am trying to checkout code from different branches (such as 8.3, 8.4). I found a few ways to checkout code from CVS: 1. webCVS: http://anoncvs.postgresql.org/cvsweb.cgi/ 2. cvs -z3 -d :pserver:anoncvs:password(a)anoncvs.postgresql.org:/projects/cvsroot co -P pgsql 3. $ rsync --progress -avzCH --delete... 8 Feb 2010 22:34