On Monday 12 January 2009, Bill Preston <billpres...@crownepointe.net> 
wrote:
> As to the second example with the delete. There are no foreign keys.
> For the index. If the table has fields a,b,c and d.
> We have a btree index (a,b,c,d)
> and we are saying DELETE FROM table_messed_up WHERE a=x.
>

Is there anything special about this table? Does it have like a hundred 
indexes on it or something? Because deleting 8k rows from a normal table 
should never take more than a couple of seconds.

-- 
Alan

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to