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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
