Re: Benchmark Data requested - Mailing list pgsql-performance

From Matthew
Subject Re: Benchmark Data requested
Date
Msg-id Pine.LNX.4.64.0802051554010.20402@aragorn.flymine.org
Whole thread Raw
In response to Re: Benchmark Data requested  (Richard Huxton <dev@archonet.com>)
Responses Re: Benchmark Data requested  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
On Tue, 5 Feb 2008, Richard Huxton wrote:
>> Why would you need to lock the table?
>
> Because you're not really writing the WAL, which means you can't let anyone
> else get their data into any of the blocks you are writing into. You'd
> basically want to write the disk blocks then "attach" them in some way.

So what's wrong with "reserving" the space using the WAL, then everyone
else will know. After all, when you write the data to the WAL, you must
have an idea of where it is meant to end up. My suggestion is that you go
through all the motions of writing the data to the WAL, just without the
data bit.

Matthew

--
Failure is not an option. It comes bundled with your Microsoft product.
                                                 -- Ferenc Mantfeld

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Benchmark Data requested
Next
From: Richard Huxton
Date:
Subject: Re: Benchmark Data requested