Re: Performance query about large tables, lots of concurrent access

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Karl Wright <kwright(at)metacarta(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance query about large tables, lots of concurrent access
Date: 2007-06-19 13:26:43
Message-ID: 20070619132643.GC4265@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Karl Wright wrote:

> This particular run lasted four days before a VACUUM became essential.
> The symptom that indicates that VACUUM is needed seems to be that the
> CPU usage of any given postgresql query skyrockets. Is this essentially
> correct?

Are you saying you weren't used to run VACUUM all the time? If so,
that's where the problem lies.

--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la amistad; jugar
al alfarero y ver qué formas se pueden sacar del otro" (C. Halloway en
La Feria de las Tinieblas, R. Bradbury)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Lew 2007-06-19 13:28:58 Re: Postgres VS Oracle
Previous Message Jonah H. Harris 2007-06-19 13:18:04 Re: [PERFORM] [ADMIN] Postgres VS Oracle