| From: | Kevin Brown <kevin(at)sysexperts(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Alex Turner <armtuk(at)gmail(dot)com> |
| Subject: | Re: LVM and Postgres |
| Date: | 2005-12-07 04:14:45 |
| Message-ID: | 20051207041445.GA6841@filer |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sysexperts(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2005-12-07 04:18:24 | Re: Query Fails with error calloc - Cannot alocate memory |
| Previous Message | Rick Schumeyer | 2005-12-07 03:06:52 | table partitioning: effects of many sub-tables (was COPY too slow...) |