Postgres Pro
Downloads
Home   >   mailing lists

Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Date
Msg-id 473C1315.6020006@enterprisedb.com
Whole thread Raw
In response to Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Responses Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-hackers
Tree view 
Jignesh K. Shah wrote:
> Since its really writes that I am having trouble.. the auto vacuum 
> message tells me 11 pages were removed and so many tuples were 
> removed..  I am guessing its writes.

Do you keep track of I/O to WAL and data separately? WAL bandwidth will 
spike up when a checkpoint starts, because of full page writes.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Spinlock backoff algorithm
Next
From: Heikki Linnakangas
Date:
Subject: Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris