Re: [HACKERS] Revisiting Re: BUG #8532: postgres fails to start with timezone-data =2013e

2015-04-11 Thread Tom Lane
Ian Stakenvicius a...@gentoo.org writes: Hey all -- so I know that Gentoo Linux is likely the only platform this bug occurs under, but i got annoyed enough with it that I decided to write a patch to fix this issue once and for all (or at least, help keep it from happening). That thread in

Re: [HACKERS] FDW oddity

2015-04-11 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: I have just noticed something slightly odd. The traces (obtained by setting client_min_messages to debug1) from the blackhole FDW show that the handler function is called each time an INSERT is performed. This is not the case for SELECT, UPDATE or

[HACKERS] FDW oddity

2015-04-11 Thread Andrew Dunstan
I have just noticed something slightly odd. The traces (obtained by setting client_min_messages to debug1) from the blackhole FDW show that the handler function is called each time an INSERT is performed. This is not the case for SELECT, UPDATE or DELETE. It looks at first glance like a

Re: [HACKERS] improving speed of make check-world

2015-04-11 Thread Michael Paquier
On Sat, Apr 11, 2015 at 4:35 AM, Peter Eisentraut pete...@gmx.net wrote: On 3/9/15 2:51 AM, Michael Paquier wrote: On Sun, Mar 8, 2015 at 10:46 PM, Michael Paquier michael.paqu...@gmail.com wrote: Speaking of which, attached is a patch rewritten in-line with those comments, simplifying a bit

Re: [HACKERS] PATCH: Spinlock Documentation

2015-04-11 Thread Artem Luzyanin
Hello, Thank you again for your feedback. I have improved the patch with your suggestions. Please let me know what you think and if I can do anything else. Current CommitFest link for this patch is:  https://commitfest.postgresql.org/5/208/ Respectfully, Artem Luzyanin On Sunday, April 5,

Re: [HACKERS] moving from contrib to bin

2015-04-11 Thread Peter Eisentraut
On 3/11/15 8:21 PM, Michael Paquier wrote: Attached is a series of patch rebased on current HEAD, there were some conflicts after perl-tidying the refactoring patch for MSVC. Note that this series still uses PGXS in the Makefiles, I am fine to update them if necessary once this matter is set

Re: [HACKERS] WIP Patch for GROUPING SETS phase 1

2015-04-11 Thread 彭瑞华
Dear: I am using postgesql 9.4.0. Thanks for your great work on grouping sets patch effort. I am now compiling postgresql from source code 9.4.0 on Linux platform with [gsp-all.patch] successed and grouping function well, but failed on window platform(windows 2003 or window 7). It shows

[HACKERS] Patch to improve a few appendStringInfo* calls

2015-04-11 Thread David Rowley
I've attached a small patch which just fixes a few appendStringInfo* calls that are not quite doing things the way that it was intended. Regards David Rowley appendstringinfo_fix.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] FDW oddity

2015-04-11 Thread Andrew Dunstan
On 04/11/2015 05:10 PM, Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: I have just noticed something slightly odd. The traces (obtained by setting client_min_messages to debug1) from the blackhole FDW show that the handler function is called each time an INSERT is performed. This

Re: [HACKERS] improving speed of make check-world

2015-04-11 Thread Michael Paquier
On Sat, Apr 11, 2015 at 8:48 PM, Michael Paquier wrote: Now, what this patch does is enforcing the temporary install for each *check target of vcregress.pl. This has the disadvantage of making the benefits of MAKELEVEL=0 seen for build methods using the Makefiles go away for MSVC A trick that

Re: [HACKERS] Replication identifiers, take 4

2015-04-11 Thread Petr Jelinek
On 10/04/15 18:03, Andres Freund wrote: On 2015-04-07 17:08:16 +0200, Andres Freund wrote: I'm starting benchmarks now. What I'm benchmarking here is the WAL overhead, since that's what we're debating. The test setup I used was a pgbench scale 10 instance. I've run with full_page_write=off

[HACKERS] Remove some duplicated words in comments

2015-04-11 Thread David Rowley
Attached is a small patch which removes some duplicated words that have crept into some comments. Regards David Rowley duplicate_words_in_comments_fix.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] FDW oddity

2015-04-11 Thread Andrew Dunstan
On 04/11/2015 07:30 PM, Andrew Dunstan wrote: On 04/11/2015 05:10 PM, Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: I have just noticed something slightly odd. The traces (obtained by setting client_min_messages to debug1) from the blackhole FDW show that the handler function is