Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-09-09 Thread Robert Haas
On Tue, Sep 9, 2014 at 8:07 AM, didier 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 not with

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-09-09 Thread Fujii Masao
On Tue, Sep 9, 2014 at 9:07 PM, didier 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. > It's n

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-08-07 Thread Fujii Masao
On Thu, Aug 7, 2014 at 5:02 PM, Heikki Linnakangas wrote: > On 08/07/2014 10:10 AM, Mitsumasa KONDO wrote: >> >> 2014-08-07 13:47 GMT+09:00 Fujii Masao : >> >>> On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas >>> wrote: On 08/06/2014 08:39 PM, Fujii Masao wrote: > > The WAL f

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 : On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas 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 the OS to

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-07 Thread Mitsumasa KONDO
Hi, 2014-08-07 13:47 GMT+09:00 Fujii Masao : > On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas > 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 the OS to release any cached page

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-06 Thread Fujii Masao
On Thu, Aug 7, 2014 at 3:59 AM, Heikki Linnakangas 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 inclined

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 enough

Re: [HACKERS] posix_fadvise() and pg_receivexlog

2014-08-06 Thread Robert Haas
On Wed, Aug 6, 2014 at 1:39 PM, Fujii Masao 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 we know that the us

[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 (pgsql-hack