Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Michael Fuhr <mike(at)fuhr(dot)org>
- Cc: Andrzej Zawadzki <zawadaa(at)wp(dot)pl>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- Date: Thu, 19 Oct 2006 10:32:51 -0400
Michael Fuhr <mike(at)fuhr(dot)org> writes: > On Thu, Oct 19, 2006 at 03:30:35PM +0200, Andrzej Zawadzki wrote: >> After upgrade PostgreSQL from 8.0 to 8.1.4 a VACUUM FULL ANALYZE >> process is much slower, from logs: > Is it possible that 8.1 was built with --enable-cassert and 8.0 > wasn't? What does "SHOW debug_assertions" show on each server? Different vacuum delay settings maybe? regards, tom lane
- References:
- VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- From: Andrzej Zawadzki
- Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- From: Michael Fuhr
- VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- Prev by Date: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- Next by Date: Re: DB Performance decreases due to often written/accessed
- Previous by thread: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- Next by thread: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
- Indexes: