| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, david(at)lang(dot)hm, Greg Smith <gsmith(at)gregsmith(dot)com>, Guillaume Cottenceau <gc(at)mnc(dot)ch>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Choosing a filesystem |
| Date: | 2008-09-23 19:01:15 |
| Message-ID: | 1222196475.4445.444.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 2008-09-23 at 13:02 -0400, Bruce Momjian wrote:
> Merlin Moncure wrote:
> > > although for postgres the thing that you are doing the fsync on is the WAL
> > > log file. that is a single (usually) contiguous file. As such it is very
> > > efficiant to write large chunks of it. so while you will degrade from the
> > > battery-only mode, the fact that the controller can flush many requests
> > > worth of writes out to the WAL log at once while you fill the cache with
> > > them one at a time is still a significant win.
> >
> > The heap files have to be synced as well during checkpoints, etc.
>
> True, but as of 8.3 those checkpoint fsyncs are spread over the interval
> between checkpoints.
No, the fsyncs still all happen in a tight window after we have issued
the writes. There's no waits in between them at all. The delays we
introduced are all in the write phase. Whether that is important or not
depends upon OS parameter settings.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colin Copeland | 2008-09-23 21:22:28 | query planner and scanning methods |
| Previous Message | Bruce Momjian | 2008-09-23 17:02:01 | Re: Choosing a filesystem |