Re: REINDEX takes half a day (and still not complete!)

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: REINDEX takes half a day (and still not complete!)
Date: 2011-04-18 06:42:08
Message-ID: BANLkTimSWquERaMa1A=MRHpdy8MV1VOPaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 18, 2011 at 8:39 AM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> Aside from a bug, that's the only reason I can think for a pg backend
> to bail out like that. Well, the connection could have been cut off by
> other means (ie: someone tripped on the cable or something), but lets
> not dwell on those options.

Sorry for the double-post, but I should add, you really should set up
some kind of monitoring, like cacti[0] with snmp or a similar setup,
so you can monitor the state of your server in detail without having
to stare at it.

[0] http://www.cacti.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-04-18 07:26:38 Re: REINDEX takes half a day (and still not complete!)
Previous Message Claudio Freire 2011-04-18 06:39:58 Re: REINDEX takes half a day (and still not complete!)