| From: | Marti Raudsepp <marti(at)juffo(dot)org> |
|---|---|
| To: | Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Streaming base backups |
| Date: | 2011-01-06 11:47:20 |
| Message-ID: | AANLkTin6YP_jTNp0OjG7e8UeCHD9q248emR_itwCqUjr@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jan 5, 2011 at 23:58, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr> wrote:
>> * Stefan mentiond it might be useful to put some
>> posix_fadvise(POSIX_FADV_DONTNEED)
>> in the process that streams all the files out. Seems useful, as long as that
>> doesn't kick them out of the cache *completely*, for other backends as well.
>> Do we know if that is the case?
>
> Maybe have a look at pgfincore to only tag DONTNEED for blocks that are
> not already in SHM?
It's not much of an improvement. For pages that we already have in
shared memory, OS cache is mostly useless. OS cache matters for pages
that *aren't* in shared memory.
Regards,
Marti
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Itagaki Takahiro | 2011-01-06 11:54:38 | Re: MULTISET patch |
| Previous Message | Florian Pflug | 2011-01-06 11:28:26 | Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE |