Re: postgres performance tunning

Поиск
Список
Период
Сортировка
От selvi88
Тема Re: postgres performance tunning
Дата
Msg-id 1292664882937-3310337.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: postgres performance tunning  (Greg Smith <greg@2ndquadrant.com>)
Ответы Re: postgres performance tunning
Список pgsql-performance

Thanks for ur suggestion, already I have gone through that url, with that
help I was able to make my configuration to work for 5K queries/second.
The parameters I changed was shared_buffer, work_mem, maintenance_work_mem
and effective_cache.
Still I was not able to reach my target.

Can u kindly tell me ur postgres configurations thereby I can get some idea
out of it.


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgres-performance-tunning-tp3307846p3310337.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

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

Предыдущее
От: selvi88
Дата:
Сообщение: Re: postgres performance tunning
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Strange optimization - xmin,xmax compression :)