Re: First set of OSDL Shared Mem scalability results, some wierdness ...

From: Kevin Brown <kevin(at)sysexperts(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: First set of OSDL Shared Mem scalability results, some wierdness ...
Date: 2004-10-09 21:01:02
Message-ID: 20041009210102.GC665@filer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

I wrote:
> That said, if it's typical for many changes to made to a page
> internally before PG needs to commit that page to disk, then your
> argument makes sense, and that's especially true if we simply cannot
> have the page written to disk in a partially-modified state (something
> I can easily see being an issue for the WAL -- would the same hold
> true of the index/data files?).

Also, even if multiple changes would be made to the page, with the
page being valid for a disk write only after all such changes are
made, the use of mmap() (in conjunction with an internal buffer that
would then be copied to the mmap()ed memory space at the appropriate
time) would potentially save a system call over the use of write()
(even if write() were used to write out multiple pages). However,
there is so much lower-hanging fruit than this that an mmap()
implementation almost certainly isn't worth pursuing for this alone.

So: it seems to me that mmap() is worth pursuing only if most internal
buffers tend to be written to only once or if it's acceptable for a
partially modified data/index page to be written to disk (which I
suppose could be true for data/index pages in the face of a rock-solid
WAL).

--
Kevin Brown kevin(at)sysexperts(dot)com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-10-09 21:56:21 Re: Security implications of config-file-location patch
Previous Message Kevin Brown 2004-10-09 20:37:12 Re: First set of OSDL Shared Mem scalability results, some wierdness ...

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-10-09 23:05:37 Re: First set of OSDL Shared Mem scalability results, some wierdness ...
Previous Message Kevin Brown 2004-10-09 20:37:12 Re: First set of OSDL Shared Mem scalability results, some wierdness ...