Postgres Pro
Downloads
Home   >   mailing lists

VACUUM ANALYZE and REINDEX - Mailing list pgsql-admin

From Bill Chandler
Subject VACUUM ANALYZE and REINDEX
Date
Msg-id 20040719192501.55745.qmail@web51402.mail.yahoo.com
Whole thread Raw
Responses Re: VACUUM ANALYZE and REINDEX  ("Scott Marlowe" <smarlowe@qwest.net>)
List pgsql-admin
Tree view 
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/

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: inheritance question
Next
From: Kris Kiger
Date:
Subject: Large file support needed? Trying to identify root of error.