Home > mailing lists

Re: REINDEX takes half a day (and still not complete!) - Mailing list pgsql-performance

From	Alan Hodgson
Subject	Re: REINDEX takes half a day (and still not complete!)
Date	April 17, 2011 18:14:16
Msg-id	201104171113.52597@hal.medialogik.com Whole thread Raw
In response to	Re: REINDEX takes half a day (and still not complete!) (Phoenix <phoenix.kiula@gmail.com>)
Responses	Re: REINDEX takes half a day (and still not complete!)
List	pgsql-performance

On April 17, 2011, Phoenix <phoenix.kiula@gmail.com> wrote:

> >> Surely this is not tenable for enterprise environments? I am on a

> >> 64bit RedHat server with dual CPU Intel Woodcrest or whatever that was

> >> called. Postgres is 8.2.9.

> >>

.. and you have essentially 1 disk drive. Your hardware is not sized for a database server.

>> it's a RAID 1 setup. Two Raptor 10000rpm disks.

From: Phoenix
Date: 17 April 2011, 17:00:14
Subject: Re: REINDEX takes half a day (and still not complete!)

From: Scott Marlowe
Date: 17 April 2011, 18:39:14
Subject: Re: REINDEX takes half a day (and still not complete!)