Re: Spread checkpoint sync - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: Spread checkpoint sync
Date
Msg-id AANLkTimG+WgKS8bHUo-wR5cgm2G15nBP9n=yrYf7=SS+@mail.gmail.com
Whole thread Raw
In response to Re: Spread checkpoint sync  (Robert Haas <robertmhaas@gmail.com>)
Responses ToDo List Item - System Table Index Clustering
List pgsql-hackers
On Sat, Jan 15, 2011 at 14:05, Robert Haas <robertmhaas@gmail.com> wrote:
> Idea #4: For ext3 filesystems that like to dump the entire buffer
> cache instead of only the requested file, write a little daemon that
> runs alongside of (and completely indepdently of) PostgreSQL.  Every
> 30 s, it opens a 1-byte file, changes the byte, fsyncs the file, and
> closes the file, thus dumping the cache and preventing a ridiculous
> growth in the amount of data to be sync'd at checkpoint time.

Wouldn't it be easier to just mount in data=writeback mode? This
provides a similar level of journaling as most other file systems.

Regards,
Marti


pgsql-hackers by date:

Previous
From: Andreas Karlsson
Date:
Subject: Re: Bug in pg_describe_object, patch v2
Next
From: Robert Haas
Date:
Subject: Re: Spread checkpoint sync