| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DELETE SQL too slow. |
| Date: | 2002-09-03 19:55:15 |
| Message-ID: | 20020903125241.L48266-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 3 Sep 2002, Diogo Biazus wrote:
> I already have ran VACUUM ANALYSE
> And I used the REINDEX too.
>
> Here is the explain:
>
> NOTICE: QUERY PLAN:
>
> Index Scan using palavrasbusca_codbusca_ix on palavrasbusca
> (cost=0.00..333.43 rows=443 width=6)
>
> My SQL is still running, it been more than one hour.
>
> The table has a reference to one other table and it has an index.
I'd guess it's related to foreign keys, but it'd be helpful to
see the statements used to create the tables and constraints/indexes
(or at least a pg_dump of those with the create index/create constraint
trigger).
Also, are there any other triggers on the table?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SamPost | 2002-09-03 20:06:54 | Creating a Cursor / Returning multiple rows |
| Previous Message | Justin Clift | 2002-09-03 19:25:24 | Re: Where can I find more information of XML support in |