On Tue, 2005-05-24 at 10:31 -0400, Vivek Khera wrote:
> On May 24, 2005, at 8:36 AM, Sven Willenberger wrote:
> 
> > "for each row"). I guess I need to look at why deleting 300k rows took
> > so long (like an hour) on a system consisting of dual opterons and 8GB
> > of RAM ...
> >
> 
> an hour on the master or on the replica?  on the master it could be  
> because you have a lot of foreign keys to check and lock.
> 
> Vivek Khera, Ph.D.
> +1-301-869-4449 x806
It was on the replica ... still looking into why it happened .. I
suspect there were some other transactions in process with more deletes
and I also saw those during the time period.

I do vacuum/analyze regularly but will increase the frequency on some of
these tables (looking into pg_autovacuum)

Sven