Re: Filesystem fragmentation (Re: Fragmentation of WAL files) - Mailing list pgsql-performance

From Tom Lane
Subject Re: Filesystem fragmentation (Re: Fragmentation of WAL files)
Date
Msg-id 26942.1177609772@sss.pgh.pa.us
Whole thread Raw
In response to Re: Filesystem fragmentation (Re: Fragmentation of WAL files)  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-performance
Gregory Stark <stark@enterprisedb.com> writes:
> In the case of a performance-critical file like the WAL that's always read
> sequentially it may be to our advantage to defeat this technique and force it
> to be allocated sequentially. I'm not sure whether any filesystems provide any
> option to do so.

We more or less do that already by filling the entire file in one go
when it's created ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Gerhard Wiesinger
Date:
Subject: Re: [GENERAL] Fw: PostgreSQL Performance Tuning
Next
From: Scott Marlowe
Date:
Subject: Re: not using indexes on large table