On Mon, May 13, 2013 at 9:54 PM, Jon Nelson <jnelson+pg...@jamponi.net> wrote:
> Pertinent to another thread titled
> [HACKERS] corrupt pages detected by enabling checksums
> I hope to explore the possibility of using fallocate (or
> posix_fallocate) for new WAL file creation.
> Most modern Linux filesystems support fast fallocate/posix_fallocate,
> reducing extent fragmentation (where extents are used) and frequently
> offering a pretty significant speed improvement. In my tests, using
> posix_fallocate (followed by pg_fsync) is at least 28 times quicker
> than using the current method (which writes zeroes followed by
> pg_fsync).
> I have written up a patch to use posix_fallocate in new WAL file
> creation, including configuration by way of a GUC variable, but I've
> not contributed to the PostgreSQL project before. Therefore, I'm
> fairly certain the patch is not formatted properly or conforms to the
> appropriate style guides. Currently, the patch is based on 9.2, and is
> quite small in size - 3.6KiB.
> Advice on how to proceed is appreciated.

Make sure to list it here:


Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to