Re: LVM and Postgres - Mailing list pgsql-performance

From Kevin Brown
Subject Re: LVM and Postgres
Date
Msg-id 20051207041445.GA6841@filer
Whole thread Raw
In response to Re: LVM and Postgres  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
Michael Stone wrote:
> Note that the WAL will
> wander around the disk as files are created and deleted, whereas tables
> are basically updated in place.

Huh?  I was rather under the impression that the WAL files (in
pg_xlog, right?) were reused once they'd been created, so their
locations on the disk should remain the same, as should their data
blocks (roughly, depending on the implementation of the filesystem, of
course).


--
Kevin Brown                          kevin@sysexperts.com

pgsql-performance by date:

Previous
From: Edison Azzi
Date:
Subject: Join the same row
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Query Fails with error calloc - Cannot alocate memory