On Tue, Jul 8, 2008 at 12:06 AM, Keaton Adams <kadams@mxlogic.com> wrote:
> An analyze is run on the tables every day (even several times a day because
> they are updated very frequently) and a vacuum analyze is run on the
> weekends. I also tried to run an analyze specifically on the customer_id
> column and then the product_id column but that didn't help.
I'm no expert, so if I'm talking nonsense here, someone please correct me.
From what I read on this list I believe you need to run VACUUM
frequently if there are many updates, at least daily,
but it could also be needed every n minutes in extreme cases, an
ANALYSE won't cut it.
(UPDATE leaves dead rows in the database, which must be filtered out
by count(*), vacuum gets rid of them)
Try a VACUUM FULL (at a time when there isn't much load on the
server), if this solves your problem, you need to decrease your VACUUM
interval.
