postgresql.conf question... CPU spikes

Поиск
Список
Период
Сортировка
От Bala Venkat
Тема postgresql.conf question... CPU spikes
Дата
Msg-id CACnhOfJqRNcQ7GKc6j6a6Z856Esafg1FrEGOot8uPNeSdu++Hw@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgresql.conf question... CPU spikes  (Andy Colson <andy@squeakycode.net>)
Re: postgresql.conf question... CPU spikes  (Venkata Balaji Nagothi <vbnpgc@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi all -

       We are running postgres 9.0 ( 32 bit ) + postgis 1.5.2 on Solaris Sparc M5000 with 64GB .  Recently we are getting CPU utilitzation to 99% .

In the config file


shared_buffers=2GB.
work_mem = 128MB
effective_cache_size=48GB
maintaince_work_mem= 500MB
max_connections = 300

When the CPU spikes happens, when I look at the pg_stat_activity log, the queries where current_query not like '%<IDLE>%' are between 100-110.

Do you think , I have to reduce the effective_cache and work_mem for this?

Thanks for your help.

В списке pgsql-general по дате отправления:

Предыдущее
От: Niels Kristian Schjødt
Дата:
Сообщение: What does "ERROR: failed to find parent tuple for heap-only tuple at (1192248,5) in table "fruits"" mean?
Следующее
От: MOHAMMED-BOUZIANE Ilyes
Дата:
Сообщение: Help