Re: [HACKERS] /proc/self/oom_adj is deprecated in newer Linux kernels

2014-07-02 Thread Christoph Berg
Re: Tom Lane 2014-07-01 <20654.1404247...@sss.pgh.pa.us> > Yeah, I'm unexcited about this proposal. In any case, given the two > existing APIs we have to deal with, allowing PG_OOM_ADJUST_VALUE to > default to "0" is sane in both APIs but a default for the file name > can work for only one. Nod.

Re: [HACKERS] 9.5 CF1

2014-07-02 Thread Etsuro Fujita
(2014/07/02 14:06), Abhijit Menon-Sen wrote: Foreign table inheritance Moved from ready for committer back to waiting on author after Noah's review comments. Should we expect an updated patch to be posted in this CF? http://archives.postgresql.org/message-id/20140702022327.

[HACKERS] Missing IPv6 for pgbuildfarm.org

2014-07-02 Thread Torsten Zuehlsdorff
Hello, i've tried to setup a FreeBSD 10 machine as buildfarm-member. But it's an IPv6 only machine and there is no IPv6 for the homepage. Can anyone add support for IPv6 to it? Greetings, Torsten -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your s

Re: [HACKERS] gaussian distribution pgbench

2014-07-02 Thread Fabien COELHO
Hello Mitsumasa-san, And I'm also interested in your "decile percents" output like under followings, decile percents: 39.6% 24.0% 14.6% 8.8% 5.4% 3.3% 2.0% 1.2% 0.7% 0.4% Sure, I'm really fine with that. I think that it is easier than before. Sum of decile percents is just 100%. That's a

Re: [HACKERS] Add the number of pinning backends to pg_buffercache's output

2014-07-02 Thread Rajeev rastogi
On 23 June 2014 15:22, Andres Freund Wrote: > > This may be harmless but pinning_backends should be defined as int4 > > rather than int8 because BufferDesc->refcount is just defined as > > unsigned and it's converted to Datum by Int32GetDatum(). > > Well, in theory a uint32 can't generally be co

Re: [HACKERS] RLS Design

2014-07-02 Thread Yeb Havinga
On 01/07/14 21:51, Robert Haas wrote: On Tue, Jul 1, 2014 at 3:20 PM, Dean Rasheed wrote: That seems like a pretty strong argument. If RLS quals are instead regarded as constraints on access, and multiple policies apply, then it seems that the quals should now be combined with AND rather than

Re: [HACKERS] WAL replay bugs

2014-07-02 Thread Kyotaro HORIGUCHI
Hello, > Thanks for your comments. Looking forward to seeing some more input. Thank you. bufcapt.c was a poser. bufcapt.c: 326 memcpy(&tail, &page[BLCKSZ - 2], 2); This seems duzzling.. Isn't "*(uint16*)(&page[BLCKSZ - 2])" applicable? bufcapt.c: 331 else if (PageGetSpecial Generally

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-07-02 Thread Abhijit Menon-Sen
At 2014-07-01 21:39:27 +0900, maumau...@gmail.com wrote: > > Won't it be burden and a headache to maintain pgaudit code when it > becomes obsolete in the near future? Maybe it's a bit unfair to single out this statement to respond to, because it seems at best tangential to your larger point, but:

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-07-02 Thread Abhijit Menon-Sen
At 2014-06-30 10:59:22 -0400, robertmh...@gmail.com wrote: > > That means we need some review of the patch for what it is, which > there hasn't been much of, yet. Regardless of the eventual fate of pgaudit, we'd certainly welcome some review of the code. -- Abhijit -- Sent via pgsql-hackers ma

Re: [HACKERS] Spinlocks and compiler/memory barriers

2014-07-02 Thread Mark Cave-Ayland
On 02/07/14 08:36, Andres Freund wrote: On 2014-07-01 20:21:37 -0400, Tom Lane wrote: Andres Freund writes: On 2014-07-01 23:21:07 +0100, Mark Cave-Ayland wrote: Also if you're struggling for Sun buildfarm animals, recent versions of QEMU will quite happily install and run later versions of

Re: [HACKERS] better atomics - v0.5

2014-07-02 Thread Andres Freund
On 2014-07-02 09:27:52 +0300, Ants Aasma wrote: > On Fri, Jun 27, 2014 at 9:00 PM, Andres Freund wrote: > > Imagine the situation for the buffer header spinlock which is one of the > > bigger performance issues atm. We could aim to replace all usages of > > that with clever and complicated logic,

Re: [HACKERS] Spinlocks and compiler/memory barriers

2014-07-02 Thread Andres Freund
On 2014-07-01 20:21:37 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2014-07-01 23:21:07 +0100, Mark Cave-Ayland wrote: > >> Also if you're struggling for Sun buildfarm animals, recent versions of > >> QEMU > >> will quite happily install and run later versions of 32-bit Solaris over > >>

Re: [HACKERS] 9.5 CF1

2014-07-02 Thread Michael Paquier
On Wed, Jul 2, 2014 at 2:44 PM, Abhijit Menon-Sen wrote: > WAL format & API changes > I'm not sure what's happening here. Will look more closely, but > updates are welcome from the people who've been participating in > the discussion/review. > Patch has been reviewed once. Heikki has

Re: [HACKERS] WAL format and API changes (9.5)

2014-07-02 Thread Michael Paquier
On Wed, Jul 2, 2014 at 4:09 PM, Michael Paquier wrote: > > 3) I noticed a bug in gin redo code path when trying to use the WAL replay > facility. > Looking at the backtrace, it seems that a page for gin is corrupted. The buffer capture patch does some sanity checks on the page format when perform

Re: [HACKERS] WAL format and API changes (9.5)

2014-07-02 Thread Michael Paquier
On Tue, Jul 1, 2014 at 5:51 AM, Heikki Linnakangas wrote: > On 06/27/2014 09:12 AM, Michael Paquier wrote: > >> 2) Description of XLogBeginInsert, XLogHasBlockRef, XLogGetBlockRef and >> XLogGetBlockRefIds are missing in src/backend/access/transam/README. >> > > Added descriptions of XLogBeginIns

<    1   2