Re: Extremely Slow Cascade Delete Operation

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Extremely Slow Cascade Delete Operation
Date: 2010-01-13 08:35:43
Message-ID: 2f4958ff1001130035g442cf78cj43b9ef2772b122d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng Cheok 2010-01-13 08:47:44 Re: Extremely Slow Cascade Delete Operation
Previous Message Yan Cheng Cheok 2010-01-13 08:28:39 Re: Extremely Slow Cascade Delete Operation