"Jeremy M. Guthrie" <[EMAIL PROTECTED]> writes: > My system will run great after a full vacuum(as I would expect). It will run > all day long taking only 3-5 seconds to run and deal with approximately > 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.
Could we see EXPLAIN ANALYZE for the deletion query in both the fast and slow states? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend