| From: | Steve Atkins <steve(at)blighty(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance issues with compaq server |
| Date: | 2002-05-08 17:53:08 |
| Message-ID: | 20020508105308.A14127@blighty.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wed, May 08, 2002 at 11:02:35AM -0400, Doug McNaught wrote:
> Holger Marzen <holger(at)marzen(dot)de> writes:
>
> > ACK. On a given hardware I get about 150 inserts per second. Using a
> > begin/end transaction for a group of 100 inserts speeds it up to about
> > 450 inserts per second.
>
> COPY is even faster as there is less query parsing to be done, plus
> you get a transaction per COPY statement even without BEGIN/END.
Does anyone have any performance figures to hand on COPY vs BEGIN/INSERT/END,
on indexed or unindexed tables?
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-05-08 18:36:28 | Re: Logging function calls to figure out lo_close log |
| Previous Message | Chris Gamache | 2002-05-08 17:48:23 | timestamp in 7.1 vs 7.2 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Marzen | 2002-05-08 20:01:05 | Re: Performance issues with compaq server |
| Previous Message | Scott Marlowe | 2002-05-08 17:21:49 | Re: postgresql 7.1 file descriptor |