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

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: REINDEX takes half a day (and still not complete!)
Дата
Msg-id 201104171113.52597@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: REINDEX takes half a day (and still not complete!)  (Phoenix <phoenix.kiula@gmail.com>)
Ответы Re: REINDEX takes half a day (and still not complete!)  (Shashank Tripathi <shanx@shanx.com>)
Список 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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Phoenix
Дата:
Сообщение: Re: REINDEX takes half a day (and still not complete!)
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: REINDEX takes half a day (and still not complete!)