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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org