Re: A smaller default postgresql.conf

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: A smaller default postgresql.conf
Дата
Msg-id 48B6ECB5.5080307@agliodbs.com
обсуждение исходный текст
Ответ на Re: A smaller default postgresql.conf  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Kevin,

> # maintenance_work_mem = 256MB  #webserver with 2GB RAM

Well, that was before multiple autovacuum workers. Now, you'd want it 
lower.  But ... it's better for vacuum to finish quickly than to drag 
on.  Vacuum uses more I/O than it does RAM.

> But I'm amazed by this, too:
>  
> # max_connections = 700  # web application database
>  
> How many CPUs and spindles are you assuming there?

I'm assuming that the user isn't using connection pooling, and 7/8 of 
those connections will be idle at any given time.

--Josh


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: WIP patch: add parser location info to most expression node types
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: A smaller default postgresql.conf