Re: performance of insert/delete/update

Scott,

> It's quite easy to test if you have a database with a large table to play
> with, use pg_dump to dump a table with the -d switch (makes the dump use
> insert statements.) Then, make two versions of the dump, one which has a
> begin;end; pair around all the inserts and one that doesn't, then use psql
> -e to restore both dumps. The difference is HUGE. Around 10 to 20 times
> faster with the begin end pairs.
>
> I'd think that anyone who's used postgresql for more than a few months
> could corroborate my experience.

Ouch!

No need to get testy about it.

Your test works as you said; the way I tried testing it before was different.
Good to know. However, this approach is only useful if you are doing
rapidfire updates or inserts coming off a single connection. But then it is
*very* useful.

--
-Josh Berkus
Aglio Database Solutions
San Francisco