Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris

Yes I separate out as follows:
PGDATA  + 1 TABLE which needs to be cached (also workaround CLOG read 
problem)
LOGS
DATABASE TABLES
DATABASE INDEX
to get a good view of IOs out

I have full_page_writes=off in my settings
I dont see spikes of increase on WAL during checkpoints (maybe due to my 
setting) but the constant load which is in the range of about 
2-2.5MB/sec which is not low but my load is high.

In my current run I do have async wal on with wal_writer_delay=100ms and 
commit_delay off.


-Jignesh

Heikki Linnakangas wrote:
> 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.
>