"Giulio Cesare Solaroli" <giulio(dot)cesare(at)gmail(dot)com> writes:
> As you may notice, the commit phase takes almost 2 full minutes. :-(
Yow. It's hard to believe that the actual commit (ie, flushing the
commit record to WAL) could take more than a fraction of a second.
I'm thinking there must be a pile of pre-commit work to do, like a
lot of deferred triggers. Do you use deferred foreign keys?
If so, the most likely bet is that the DELETE is triggering a lot
of deferred FK checks, and these are slow for some reason (maybe
another missing index).
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Gregory Stark||Date: 2007-10-24 13:17:22|
|Subject: Re: multiple apaches against single postgres database|
|Previous:||From: Jean-David Beyer||Date: 2007-10-24 13:14:42|
|Subject: Re: 12 hour table vacuums|