Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb -z do a reindex? - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: vacuumdb -z do a reindex?
Date
Msg-id 200911272329.57120.guillaume@lelarge.info
Whole thread Raw
In response to vacuumdb -z do a reindex?  (Irene Barg <ibarg@noao.edu>)
List pgsql-general
Tree view 
Le vendredi 27 novembre 2009 à 22:17:50, Irene Barg a écrit :
> I thought 'vacuumdb -z dbname' also reindex is this true?
>

No. vacuumdb -z is a VACUUM ANALYZE. Moreover, vacuumdb has no option to do a
REINDEX.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgsql-general by date:

Previous
From: Irene Barg
Date:
Subject: vacuumdb -z do a reindex?
Next
From: Jeff Amiel
Date:
Subject: Re: empty string causes planner to avoid index. Makes me sad.