Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Vacuum takes forever
- From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Vacuum takes forever
- Date: Wed, 30 May 2007 10:11:04 -0400
On Tue, May 29, 2007 at 07:56:07PM +0200, Joost Kraaijeveld wrote:
> Thanks, I tried it and it worked. I did not know that changing this
> setting would result in such a performance drop ( I just followed an
It's not a performance drop. It's an on-purpose delay of the
functionality, introduced so that _other_ transactions don't get I/O
starved. ("Make vacuum fast" isn't in most cases an interesting
goal.)
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin
- References:
- Vacuum takes forever
- From: Joost Kraaijeveld
- Re: Vacuum takes forever
- From: PFC
- Re: Vacuum takes forever
- From: Joost Kraaijeveld
- Vacuum takes forever
- Prev by Date: Re: Bad RAID1 read performance
- Next by Date: Re: setting up raid10 with more than 4 drives
- Previous by thread: Re: Vacuum takes forever
- Next by thread: Re: Vacuum takes forever
- Indexes: