Re: [PERFORM] Query plan from hell

2006-03-25 Thread Guido Neitzer
On 24.03.2006, at 23:54 Uhr, PFC wrote: bookmark_delta contains very few rows but is inserted/deleted very often... the effect is spectacular ! I guess I'll have to vacuum analyze this table every minute... What about using autovacuum? cug -- PharmaLine, Essen, GERMANY Software an

[PERFORM] Query plan from hell

2006-03-24 Thread PFC
Whoa ! bookmark_delta contains very few rows but is inserted/deleted very often... the effect is spectacular ! I guess I'll have to vacuum analyze this table every minute... annonces=# EXPLAIN ANALYZE SELECT id, priority FROM annonces WHERE id IN (SELECT annonce_id FROM b