"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

Reply via email to