pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kevin Brown <kevin@sysexperts.com>
To: pgsql-performance@postgresql.org
Cc: Alex Turner <armtuk@gmail.com>
Subject: Re: LVM and Postgres
Date: Tue, 6 Dec 2005 20:14:45 -0800
Message-ID: <20051207041445.GA6841@filer> (raw)
In-Reply-To: <20051207013107.GP7330@mathom.us>
References: <20051206093818.GE6708@campbell-lange.net>
	<dn4rb3$2d55$1@news.hub.org>
	<20051206213623.GD14427@campbell-lange.net>
	<20051207002537.GN7330@mathom.us>
	<33c6269f0512061652u73a690t8af8a276118b1a83@mail.gmail.com>
	<20051207013107.GP7330@mathom.us>

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



view thread (8+ messages)  latest in thread

Message-ID: <20051207041445.GA6841@filer>
Permalink:  ../20051207041445.GA6841@filer/
Also on:    postgresql.org/message-id/20051207041445.GA6841@filer

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: kevin@sysexperts.com, armtuk@gmail.com
  Subject: Re: LVM and Postgres
  In-Reply-To: <20051207041445.GA6841@filer>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox