| From: | Ivan Voras <ivoras(at)fer(dot)hr> |
|---|---|
| To: | Rod Taylor <rbt(at)rbt(dot)ca> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Optimizing DELETE |
| Date: | 2006-09-19 20:39:42 |
| Message-ID: | 4510558E.7020205@fer.hr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Rod Taylor wrote:
> On Tue, 2006-09-19 at 15:22 +0200, Ivan Voras wrote:
>> I've just fired off a "DELETE FROM table" command (i.e. unfiltered
>> DELETE) on a trivially small table but with many foreign key references
>> (on similar-sized tables), and I'm waiting for it to finish. It's been
>> 10 minutes now, which seems very excessive for a table of 9000 rows on a
>> 3 GHz desktop machine.
>
> I would guess that a few of those referenced tables are missing indexes
> on the referenced column.
Yes, it was a pilot error :(
Among the small and properly indexed referencing tables there was a
seldom queried but huge log table.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Milen Kulev | 2006-09-19 20:43:33 | Pipelined functions in Postgres |
| Previous Message | Mark Lewis | 2006-09-19 14:17:25 | Re: Optimizing DELETE |