Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Optimizing DELETE
- 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: Tue, 19 Sep 2006 22:39:42 +0200
- Message-id: <4510558E(dot)7020205(at)fer(dot)hr>
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.
- References:
- Optimizing DELETE
- From: Ivan Voras
- Re: Optimizing DELETE
- From: Rod Taylor
- Optimizing DELETE
- Prev by Date: Re: Optimizing DELETE
- Next by Date: Pipelined functions in Postgres
- Previous by thread: Re: Optimizing DELETE
- Next by thread: Re: Optimizing DELETE
- Indexes: