Re: Performance query about large tables, lots of concurrent access - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Performance query about large tables, lots of concurrent access
Date
Msg-id 20070619132643.GC4265@alvh.no-ip.org
Whole thread Raw
In response to Re: Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
Responses Re: Performance query about large tables, lots of concurrent access
List 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)

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
Next
From: Karl Wright
Date:
Subject: Re: Performance query about large tables, lots of concurrent access