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

VACUUM ANALYZE and REINDEX

From: Bill Chandler <billybobc1210(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: VACUUM ANALYZE and REINDEX
Date: 2004-07-19 19:25:01
Message-ID: 20040719192501.55745.qmail@web51402.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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)?

thanks,

Bill


		
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/


Responses

pgsql-admin by date

Next:From: Kris KigerDate: 2004-07-19 19:28:48
Subject: Large file support needed? Trying to identify root of error.
Previous:From: Tom LaneDate: 2004-07-19 16:56:04
Subject: Re: [HACKERS] Point in Time Recovery

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