Skip site navigation (1) Skip section navigation (2)

Re: Affect of Reindexing on Vacuum Times

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Y Sidhu <ysidhu(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Affect of Reindexing on Vacuum Times
Date: 2007-07-26 23:27:59
Message-ID: 0A979E6F-939A-4A45-B4EA-268EAB3E5C4F@decibel.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Jul 25, 2007, at 11:53 AM, Y Sidhu wrote:
> I am wondering if reindexing heavily used tables can have an impact  
> on vacuum times. If it does, will the impact be noticeable the next  
> time I vacuum? Please note that I am doing vacuum, not vacuum full.
>
> I am on a FreeBSD 6.1 Release, Postgresql is 8.09
>
> Currently I seeing a phenomenon where vacuum times go up beyond 1  
> hour. After I re-index 3 tables, heavily used, the vacuum times  
> stay up for the next 3 daily vacuums and then come down to 30 to 40  
> minutes. I am trying to see if there is a relationship between re- 
> indexinf and vacuum times. All other things remain the same. Which  
> means the only change I am performing is re-indexing.

Reindex will shrink index sizes, which will speed up vacuuming. But  
that alone doesn't explain what you're seeing, which is rather odd.
--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2007-07-27 00:48:36
Subject: Re: disk filling up
Previous:From: Luke LonerganDate: 2007-07-26 23:17:32
Subject: Re: update, truncate and vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group