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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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