if you're doing updates in a single transaction, you'll realize speed gains
by distributing the updates into multiple transactions. postgres won't have
to keep multiple copies that way.
hth
kapil
> >
> > 3) executed this statement tons of times:
> >
> >update test set data=1234 where key
"Ender" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm tried to cancel long running query in the PgAdmin. Run query, press
> [Cancel query] button and voila. Program stil live but i'm can't run
> queries anymore. Run query butto
Hi, all.
I'm tried to cancel long running query in the PgAdmin. Run query, press
[Cancel query] button and voila. Program stil live but i'm can't run queries
anymore. Run query button still disabled. Close query tool, open query tool
and program hang.
---(end of broa
