On 2 Oct 2007 at 23:55, Giulio Cesare Solaroli wrote: > What I have observed are impossibly high time on delete statements on > some tables. > > The delete statement is very simple: > delete from table where pk = ? > > The explain query report a single index scan on the primary key index, > as expected. > > I have run vacuum using the pgAdmin tool, but to no avail. > > I have also dropped and recreated the indexes, again without any benefit. > > I have later created a copy of the table using the "create table > table_copy as select * from table" syntax. > > Matching the configuration of the original table also on the copy > (indexes and constraints), I was able to delete the raws from the new > table with regular performances, from 20 to 100 times faster than > deleting from the original table. There may be more to that original table. What about triggers? rules? Perhaps there other things going on in the background. -- Dan Langille - http://www.langille.org/ Available for hire: http://www.freebsddiary.org/dan_langille.php ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
