Re: Checkpoint cost, looks like it is WAL/CRC - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Checkpoint cost, looks like it is WAL/CRC
Date
Msg-id Pine.OSF.4.61.0507081634050.187984@kosh.hut.fi
Whole thread Raw
In response to Re: Checkpoint cost, looks like it is WAL/CRC  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 7 Jul 2005, Tom Lane wrote:

> We still don't know enough about the situation to know what a solution
> might look like.  Is the slowdown Josh is seeing due to the extra CPU
> cost of the CRCs, or the extra I/O cost, or excessive locking of the
> WAL-related data structures while we do this stuff, or ???.  Need more
> data.

I wonder if a different BLCKSZ would make a difference either way. Say, 
1024 bytes instead of the default 8192.

- Heikki


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC
Next
From: Dennis Bjorklund
Date:
Subject: Re: SQL99 - Nested Tables