| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, pgsql-performance(at)postgresql(dot)org, "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)sun(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com> |
| Subject: | Re: Benchmark Data requested |
| Date: | 2008-02-05 15:26:47 |
| Message-ID: | 1202225207.4252.718.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-02-05 15:52:10 | Re: Benchmark Data requested |
| Previous Message | Matthew | 2008-02-05 15:25:52 | Re: Benchmark Data requested |