On Sat, 19 Jul 2003, Jeremy M. Guthrie wrote:

> 100megs of new data each day.  However, the instant the system finishes only 
> a 'vacuum analyze', the whole thing slows WAY down to where each run can take 
> 10-15 minutes.

Have you run EXPLAIN ANALYZE on the delete query before and after the 
vacuum? Does it explain why it goes slower?

-- 
/Dennis


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to