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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: REINDEX takes half a day (and still not complete!)
Date: 2011-04-18 07:38:10
Message-ID: BANLkTimafnzdL7xaa2DXyCS4ANjyXJEAZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Apr 17, 2011 at 11:19 PM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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.
>
> I have a hardware RAID controller, not "fake". It's a good quality
> battery-backed 3Ware:
> http://192.19.193.26/products/serial_ata2-9000.asp

(please stop top posting)

Also, when you run top and hit c what do those various postgres
processes say they're doing? bgwriter, SELECT, VACUMM etc?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Phoenix Kiula 2011-04-18 07:45:27 Re: REINDEX takes half a day (and still not complete!)
Previous Message Scott Marlowe 2011-04-18 07:35:13 Re: REINDEX takes half a day (and still not complete!)