| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | James Bottomley <James(dot)Bottomley(at)hansenpartnership(dot)com> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Hannu Krosing <hannu(at)2ndquadrant(dot)com>, "lsf-pc(at)lists(dot)linux-foundation(dot)org" <lsf-pc(at)lists(dot)linux-foundation(dot)org>, Kevin Grittner <kgrittn(at)ymail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Dave Chinner <david(at)fromorbit(dot)com>, Joshua Drake <jd(at)commandprompt(dot)com>, Claudio Freire <klaussfreire(at)gmail(dot)com>, Mel Gorman <mgorman(at)suse(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Trond Myklebust <trondmy(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net> |
| Subject: | Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance |
| Date: | 2014-01-15 13:42:16 |
| Message-ID: | CA+TgmobawisrktqYZC_7PAwSWt+kWvFDChUuzwxivAAiGSKg6Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jan 14, 2014 at 4:23 PM, James Bottomley
<James(dot)Bottomley(at)hansenpartnership(dot)com> wrote:
> Yes, that's what I was thinking: it's a cache. About how many files
> comprise this cache? Are you thinking it's too difficult for every
> process to map the files?
No, I'm thinking that would throw cache coherency out the window.
Separate mappings are all well and good until somebody decides to
modify the page, but after that point the database processes need to
see the modified version of the page (which is, further, hedged about
with locks) yet the operating system MUST NOT see the modified version
of the page until the write-ahead log entry for the page modification
has been flushed to disk. There's really no way to do that without
having our own private cache.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2014-01-15 13:55:02 | Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance |
| Previous Message | Hannu Krosing | 2014-01-15 13:38:44 | Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance |