Postgres Pro
Downloads
Home   >   mailing lists

Re: reindexdb dying with SIGPIPE on 8.2.5 - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: reindexdb dying with SIGPIPE on 8.2.5
Date
Msg-id 494A029A.5090503@lelarge.info
Whole thread Raw
In response to Re: reindexdb dying with SIGPIPE on 8.2.5  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Responses Re: reindexdb dying with SIGPIPE on 8.2.5  (Michael Monnerie <michael.monnerie@is.it-management.at>)
List pgsql-admin
Tree view 
Michael Monnerie a écrit :
> On Mittwoch 06 August 2008 Torsten Luettgert wrote:
>> reindexdb dbname
>> vacuumdb -f -z dbname
>
> Just a question on this: Is the order correct or would a vacuum+reindex
> be more correct?
>

You should do a VACUUM and then a REINDEX.


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

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Re: pg_xlog
Next
From: Michael Monnerie
Date:
Subject: Re: How to specify fillrate after pg_restore?