Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group