Re: reindexdb dying with SIGPIPE on 8.2.5

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Michael Monnerie <michael(dot)monnerie(at)is(dot)it-management(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: reindexdb dying with SIGPIPE on 8.2.5
Date: 2008-12-18 07:58:18
Message-ID: 494A029A.5090503@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2008-12-18 10:04:30 Re: How to specify fillrate after pg_restore?
Previous Message Naomi Walker 2008-12-18 02:40:42 Re: pg_xlog