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: (view raw, whole thread or download thread mbox)
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      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-2017 The PostgreSQL Global Development Group