Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-09-09 Thread didier
Hi Well, I'd like to hear someone from the field complaining that pg_receivexlog is thrashing the cache and thus reducing the performance of some other process. Or a least a synthetic test case that demonstrates that happening. It's not with pg_receivexlog but it's related. On a small box

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-09-09 Thread Fujii Masao
On Tue, Sep 9, 2014 at 9:07 PM, didier did...@gmail.com wrote: Hi Well, I'd like to hear someone from the field complaining that pg_receivexlog is thrashing the cache and thus reducing the performance of some other process. Or a least a synthetic test case that demonstrates that happening.

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-09-09 Thread Robert Haas
On Tue, Sep 9, 2014 at 8:07 AM, didier did...@gmail.com wrote: Well, I'd like to hear someone from the field complaining that pg_receivexlog is thrashing the cache and thus reducing the performance of some other process. Or a least a synthetic test case that demonstrates that happening. It's

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-07 Thread Mitsumasa KONDO
Hi, 2014-08-07 13:47 GMT+09:00 Fujii Masao masao.fu...@gmail.com: On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 08/06/2014 08:39 PM, Fujii Masao wrote: The WAL files that pg_receivexlog writes will not be re-read soon basically, so we can advise

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-07 Thread Heikki Linnakangas
On 08/07/2014 10:10 AM, Mitsumasa KONDO wrote: 2014-08-07 13:47 GMT+09:00 Fujii Masao masao.fu...@gmail.com: On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 08/06/2014 08:39 PM, Fujii Masao wrote: The WAL files that pg_receivexlog writes will not be

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-07 Thread Fujii Masao
On Thu, Aug 7, 2014 at 5:02 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 08/07/2014 10:10 AM, Mitsumasa KONDO wrote: 2014-08-07 13:47 GMT+09:00 Fujii Masao masao.fu...@gmail.com: On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 08/06/2014

[HACKERS] posix_fadvise() and pg_receivexlog

2014-08-06 Thread Fujii Masao
Hi, The WAL files that pg_receivexlog writes will not be re-read soon basically, so we can advise the OS to release any cached pages when WAL file is closed. I feel inclined to change pg_receivexlog that way. Thought? Regards, -- Fujii Masao -- Sent via pgsql-hackers mailing list

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-06 Thread Robert Haas
On Wed, Aug 6, 2014 at 1:39 PM, Fujii Masao masao.fu...@gmail.com wrote: The WAL files that pg_receivexlog writes will not be re-read soon basically, so we can advise the OS to release any cached pages when WAL file is closed. I feel inclined to change pg_receivexlog that way. Thought? How do

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-06 Thread Heikki Linnakangas
On 08/06/2014 08:39 PM, Fujii Masao wrote: Hi, The WAL files that pg_receivexlog writes will not be re-read soon basically, so we can advise the OS to release any cached pages when WAL file is closed. I feel inclined to change pg_receivexlog that way. Thought? -1. The OS should be smart

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-06 Thread Fujii Masao
On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 08/06/2014 08:39 PM, Fujii Masao wrote: Hi, The WAL files that pg_receivexlog writes will not be re-read soon basically, so we can advise the OS to release any cached pages when WAL file is closed. I feel