Re: Benchmark Data requested

On Tue, 2008-02-05 at 15:05 +0000, Richard Huxton wrote:

> > Only by locking the table, which serializes access, which then slows you
> > down or at least restricts other options. Plus if you use pg_loader then
> > you'll find only the first few rows optimized and all the rest not.
>
> Hmm - the table-locking requirement is true enough, but why would
> pg_loader cause problems after the first few rows?

It runs a stream of COPY statements, so only first would be optimized
with the "empty table optimization".

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com