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 <[email protected]> wrote: > From: Grzegorz Jaśkiewicz <[email protected]> > Subject: Re: [GENERAL] Extremely Slow Cascade Delete Operation > To: "Yan Cheng Cheok" <[email protected]> > Cc: [email protected] > 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
