8.2.13 commit is taking too much time

Поиск
Список
Период
Сортировка
От AI Rumman
Тема 8.2.13 commit is taking too much time
Дата
Msg-id BANLkTimRRj1KX5YXWyjcc9wQZJuEMgxAsA@mail.gmail.com
обсуждение исходный текст
Ответы Re: 8.2.13 commit is taking too much time  (tv@fuzzy.cz)
Re: 8.2.13 commit is taking too much time  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-performance
I am using Postgresql 8.2.13 and I found that most of the commits and insert or update statements  are taking more than 4s in the db and the app performance is slow for that.
My db settings are as follows;
bgwriter_all_maxpages  | 300     |
 bgwriter_all_percent  | 15      |
 bgwriter_delay        | 300     | ms
 bgwriter_lru_maxpages | 50      |
 bgwriter_lru_percent  | 10      |
 
SHOW checkpoint_segments ;
 checkpoint_segments
---------------------
 300
(1 row)

 show work_mem ;
 work_mem
----------
 16MB
(1 row)

 show checkpoint_timeout ;
 checkpoint_timeout
--------------------
 5min
(1 row)

 show checkpoint_warning ;
 checkpoint_warning
--------------------
 30s
(1 row)

show shared_buffers ;
 shared_buffers
----------------
 4GB
(1 row)


I have 32 gb RAM and its a 4*2=8 core processors.
Any idea how to improve the performance?


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

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: Benchmarking a large server
Следующее
От: Sethu Prasad
Дата:
Сообщение: Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226