Re: Extremely Slow Cascade Delete Operation - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Extremely Slow Cascade Delete Operation
Date
Msg-id 2f4958ff1001130035g442cf78cj43b9ef2772b122d4@mail.gmail.com
Whole thread Raw
In response to Re: Extremely Slow Cascade Delete Operation  (Yan Cheng Cheok <yccheok@yahoo.com>)
Responses Re: Extremely Slow Cascade Delete Operation  (Yan Cheng Cheok <yccheok@yahoo.com>)
Re: Extremely Slow Cascade Delete Operation  (Yan Cheng Cheok <yccheok@yahoo.com>)
List pgsql-general
It doesn't look like it is locked, so it is carrying the delete out.
However that doesn't mean, that there isn't any other locking
occurring, or simply your disks are rather busy.

Also, maybe the DB is rather big, what are the table sizes ?
If you are using 8.4+, than do \dt+ to get an idea, otherwise SELECT
pg_size_pretty(pg_total_relation_size('table_name')); for each table.

pgsql-general by date:

Previous
From: Yan Cheng Cheok
Date:
Subject: Re: Extremely Slow Cascade Delete Operation
Next
From: Yan Cheng Cheok
Date:
Subject: Re: Extremely Slow Cascade Delete Operation