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