Re: reindexdb dying with SIGPIPE on 8.2.5

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
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-19 03:09:59
Message-ID: 20081219030959.GM5447@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin

Michael Monnerie wrote:
> On Donnerstag 18 Dezember 2008 Guillaume Lelarge wrote:
> > You should do a VACUUM and then a REINDEX.
>
> Thank you. And as I just learned about CLUSTER... would the correct
> order be CLUSTER, VACUUM, REINDEX ? I guess so, as CLUSTER helps a lot
> with cleaning up already, so there's less work for VACUUM/REINDEX.
> Right?

You don't need to vacuum or reindex after a cluster; it removes all dead
rows (except those that vacuum won't remove anyway)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laszlo Nagy 2008-12-19 08:54:36 Re: rebellious pg stats collector (reopened case)
Previous Message Michael Monnerie 2008-12-19 02:11:57 Re: reindexdb dying with SIGPIPE on 8.2.5