Re: [Testperf-general] Re: ExclusiveLock - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: [Testperf-general] Re: ExclusiveLock
Date
Msg-id 200411181450.59521.josh@agliodbs.com
Whole thread Raw
In response to Re: [Testperf-general] Re: ExclusiveLock  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [Testperf-general] Re: ExclusiveLock
List pgsql-hackers
Simon, Tom,

> The main problem on INSERTs is that it is usually the same few pages:
> the lead data block and the lead index block. There are ways of
> spreading the load out across an index, but I'm not sure what happens on
> the leading edge of the data relation, but I think it hits the same
> block each time.

I actually have several test cases for this, can you give me a trace or 
profile suggestion that would show if this is happening?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [Testperf-general] Re: ExclusiveLock
Next
From: Tom Lane
Date:
Subject: Re: [Testperf-general] Re: ExclusiveLock