Postgres Pro
Downloads
Home   >   mailing lists

Re: Reindex does not finish 8.2.6 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Reindex does not finish 8.2.6
Date
Msg-id 20080313172502.GA6645@alvh.no-ip.org
Whole thread Raw
In response to Reindex does not finish 8.2.6  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: Reindex does not finish 8.2.6  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
List pgsql-general
Tree view 
Clodoaldo escribió:

> Now what is happening is that reindex does not finish even with a
> small 6,500 rows table and after a reboot. In top there is no CPU or
> memory usage by postmaster and vmstat shows no disk activity.

Hmm, are you vacuuming the system catalogs appropriately?

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

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: Can't rename an existnig DB because it doesn't exist???
Next
From: Craig Ringer
Date:
Subject: Re: Functional Index Question