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

Re: VACUUM ANALYZE and REINDEX

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Bill Chandler" <billybobc1210(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE and REINDEX
Date: 2004-07-19 20:06:53
Message-ID: 1090267613.709.3.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, 2004-07-19 at 13:25, Bill Chandler wrote:
> Hello,
> 
> I'm sorry if this too basic.  I searched the web but
> could not find an answer.
> 
> Q1: When you do a VACUUM ANALYZE does it update the
> statistics for existing indexes on the table?  Or do
> you have to do an explicit REINDEX command on the
> index (or possibly drop and recreate the index)?

analyze has no effect on indexes, it is performed on the tables
directly.  The stats are then used to decide when to use / not use an
index.  Reindexing is used to fix broken or bloated indexes, and is not
related to analyze.


In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2004-07-19 20:07:54
Subject: Re: Large file support needed? Trying to identify root of
Previous:From: Tom LaneDate: 2004-07-19 20:00:21
Subject: Re: Large file support needed? Trying to identify root of error.

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