VACUUM ANALYZE and REINDEX

[Bill Chandler]

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/


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Scott Marlowe]

Post by Bill Chandler
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.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org