On 01/06/2011, at 11:45 AM, Jarrod Chesney wrote:
> I'm executing 30,000 single delete statements in one transaction.
>
> At this point i'm looking into combining the multiple deletes into one
> statement and breaking my big transaction into smaller ones of about 100
&g
I'm executing 30,000 single delete statements in one transaction.
At this point i'm looking into combining the multiple deletes into one
statement and breaking my big transaction into smaller ones of about 100
deletes or so.
On 01/06/2011, at 11:40 AM, Craig Ringer wrote:
> On 1/06/2011 7:11 A
looked though all the feilds that relate to the "ID" in the base table and
created btree indexes for them.
Can anyone outline what I need to verify/do to ensure i'm getting the best
performance for my deletes?
Regards, Jarrod Chesney
--
Sent via pgsql-performance mailing list (pg
