Marty Scholes wrote:
I have seen similar results to what you are describing.

I found that running a full vacuum:

vacuumdb -fza

followed by a checkpoint makes it run fast again.

Try timing the update with and without a full vacuum.

Will do. I'll let you know how it goes.

Thanks for the reply.


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

Reply via email to