Re: Extremely Slow Cascade Delete Operation

It looks like this :

http://sites.google.com/site/yanchengcheok/Home/log.txt

I put it in google site, for easy reading)

Any hint? Thanks!

Thanks and Regards
Yan Cheng CHEOK

--- On Wed, 1/13/10, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> wrote:

> From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
> Subject: Re: [GENERAL] Extremely Slow Cascade Delete Operation
> To: "Yan Cheng Cheok" <yccheok(at)yahoo(dot)com>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Wednesday, January 13, 2010, 4:13 PM
> try checking if it is waiting perhaps
> for something (is locked).
>
> Peek at: (using different connection)
> SELECT * FROM pg_stat_activity;
> SELECT * FROM pg_locks;
>
> Did you used prepared transactions ?
> Try:
> SELECT * FROM pg_prepared_xacts ;
>
> Maybe some other transaction is blocking it.
>
>
> HTH
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>