Re: vacuumdb -z do a reindex?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgsql-general(at)postgresql(dot)org, ibarg(at)noao(dot)edu
Subject: Re: vacuumdb -z do a reindex?
Date: 2009-11-27 22:29:57
Message-ID: 200911272329.57120.guillaume@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2009-11-27 22:32:14 Re: empty string causes planner to avoid index. Makes me sad.
Previous Message Tom Lane 2009-11-27 22:15:41 Re: Cannot allocate memory for output buffer