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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Performance query about large tables, lots of concurrent access
Дата
Msg-id 20070619132643.GC4265@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
Ответы Re: Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: [pgsql-advocacy] [ADMIN] Postgres VS Oracle
Следующее
От: Karl Wright
Дата:
Сообщение: Re: Performance query about large tables, lots of concurrent access