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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: REINDEX takes half a day (and still not complete!)
Дата
Msg-id BANLkTinMjAzqEooHOxwyPaMnhf8ECLcVzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: REINDEX takes half a day (and still not complete!)  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Ответы Re: REINDEX takes half a day (and still not complete!)  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
On Sun, Apr 17, 2011 at 11:19 PM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> Btw, hardware is not an issue. My db has been working fine for a
> while. Smaller poorer systems around the web run InnoDB databases. I
> wouldn't touch that with a barge pole.

Did you or someone in an earlier post say that you didn't have
problems with table bloat?  I can't remember for sure.

Anyway if it's not hardware then it's drivers or your OS.  The output
of iostat is abysmally bad.  100% utilization but actual throughput is
pretty low.  Have you used the CLI utility for your RAID card to check
for possible problems or errors?  Maybe your battery is dead or
non-functioning?  Don't just rule out hardware until you're sure yours
is working well.

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

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