Re: [HACKERS] [TODO] Track number of files ready to be archived in pg_stat_archiver

2014-11-23 Thread Michael Paquier
Hearing nothing from the original author, this patch that was in state "Waiting on Author" for a couple of days is switched to "returned with feedback". Regards, -- Michael

Re: [HACKERS] postgres_fdw behaves oddly

2014-11-23 Thread Ashutosh Bapat
On Sun, Nov 23, 2014 at 2:46 AM, Tom Lane wrote: > Etsuro Fujita writes: > > (2014/11/19 18:21), Ashutosh Bapat wrote: > >> Ok. I added that comment to the commitfest and changed the status to > >> "ready for commiter". > > > Many thanks! > > I committed this with some cosmetic adjustments, and

Re: [HACKERS] TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

2014-11-23 Thread Amit Kapila
On Mon, Nov 24, 2014 at 7:34 AM, Dilip kumar wrote: > > On 23 November 2014 14:45, Amit Kapila Wrote > > > > Thanks a lot for debugging and fixing the issue.. > > > > Latest patch is attached, please have a look. > I think still some of the comments given upthread are not handled: a. About canc

Re: [HACKERS] TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

2014-11-23 Thread Dilip kumar
On 23 November 2014 14:45, Amit Kapila Wrote Thanks a lot for debugging and fixing the issue.. >The stacktrace of crash is as below: >#0 0x0080108cf3a4 in .strlen () from /lib64/libc.so.6 >#1 0x0080108925bc in ._IO_vfprintf () from /lib64/libc.so.6 >#2 0x0080108bc1e0 in .__GL__IO_

Re: [HACKERS] group locking: incomplete patch, just for discussion

2014-11-23 Thread Andres Freund
On 2014-11-21 08:31:01 -0500, Robert Haas wrote: > On Thu, Nov 20, 2014 at 8:31 PM, Andres Freund wrote: > >> I can't follow that logic. Why do you think self-exclusive locks are > >> the only ones that matter? > > > > All the others can be acquired by jumping in front of the lock's > > waitqueue

Re: [HACKERS] Turning recovery.conf into GUCs

2014-11-23 Thread Andres Freund
On 2014-11-21 10:59:23 -0800, Josh Berkus wrote: > On 11/21/2014 10:54 AM, Stephen Frost wrote: > > * Josh Berkus (j...@agliodbs.com) wrote: > >>> Either way, from the code it is clear that we only stay in recovery if > >>> standby_mode is directly turned on. This makes the whole check for a > >>>

Re: [HACKERS] superuser() shortcuts

2014-11-23 Thread Andres Freund
On 2014-11-21 10:12:40 -0500, Stephen Frost wrote: > * Andres Freund (and...@2ndquadrant.com) wrote: > > I still think this change makes the error message more verbose, without > > any win in clarity. > > Can we agree that there should be consistency? Consistency with what? Are you thinking of th

Re: [HACKERS] proposal: plpgsql - Assert statement

2014-11-23 Thread Tom Lane
I wrote: > The core of that complaint is that we'd have to make ASSERT a plpgsql > reserved word, which is true enough as things stand today. However, > why is it that plpgsql statement-introducing keywords need to be > reserved? The only reason for that AFAICS is to allow us to distinguish > the

[HACKERS] make check-world regress failed

2014-11-23 Thread Vladimir Koković
Hi, PostgreSQL check-world regress failed with current GIT HEAD on my Kubuntu 14.10. uname -a Linux vlD-kuci 3.16.0-24-generic #32-Ubuntu SMP Tue Oct 28 13:13:18 UTC 2014 i686 athlon i686 GNU/Linux gdb -d /home/src/postgresql-devel/postgresql-git/postgresql/src -c core ... Loaded symbols

Re: [HACKERS] Patch to support SEMI and ANTI join removal

2014-11-23 Thread David Rowley
On Wed, Nov 19, 2014 at 11:49 PM, David Rowley wrote: > On Sun, Nov 16, 2014 at 12:19 PM, David Rowley > wrote: > >> On Sun, Nov 16, 2014 at 10:09 AM, Simon Riggs >> wrote: >> >>> >>> I propose that we keep track of whether there are any potentially >>> skippable joins at the top of the plan. W