From: | Holger Marzen <holger(at)marzen(dot)de> |
---|---|
To: | Doug McNaught <doug(at)wireboard(dot)com> |
Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com>, <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Performance issues with compaq server |
Date: | 2002-05-08 20:01:05 |
Message-ID: | Pine.LNX.4.44.0205082155550.7269-100000@bluebell.marzen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On 8 May 2002, 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.
Yes, but I wanted to change something in some rows, so I used perl and
insert.
> > But beware: if one insert fails (duplicate key, faulty data) then you
> > have to re-insert the remaining rows as single transactions, else all
> > rows of the previous transaction are discarded.
>
> Hmm don't you have to ROLLBACK and redo the whole transaction without
> the offending row(s), since you can't commit while in ABORT state? Or
> am I misunderstanding?
Postgres complains and doesn't accept the following inserts after a
failed one until end of transaction. I didn't have the time yet to
figure out if it rolls back the preceeding inserts.
Is there a rule in SQL standards that describes what should happen if
some statemens in a transaction fail and the program issues a commit?
--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-05-08 20:34:05 | Re: timestamp in 7.1 vs 7.2 |
Previous Message | Dave Cramer | 2002-05-08 18:36:28 | Re: Logging function calls to figure out lo_close log |
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Hallstrom | 2002-05-08 20:31:39 | Re: CURSOR/FETCH vs LIMIT/OFFSET |
Previous Message | Steve Atkins | 2002-05-08 17:53:08 | Re: Performance issues with compaq server |