Re: Auto-tuning work_mem and maintenance_work_mem

Поиск
Список
Период
Сортировка
От MauMau
Тема Re: Auto-tuning work_mem and maintenance_work_mem
Дата
Msg-id 6EF3C60AC46040C9A6CB178D8E13AD9C@maumau
обсуждение исходный текст
Ответ на Auto-tuning work_mem and maintenance_work_mem  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Auto-tuning work_mem and maintenance_work_mem  (Bruce Momjian <bruce@momjian.us>)
Re: Auto-tuning work_mem and maintenance_work_mem  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Список pgsql-hackers
From: "Bruce Momjian" <bruce@momjian.us>
> I will work on auto-tuning temp_buffers next.  Any other suggestions?
> wal_buffers is already auto-tuned.

Great work.  I'm looking forward to becoming able to fully utilize system 
resources right after initdb.

Although this is not directly related to memory, could you set 
max_prepared_transactions = max_connections at initdb time?  People must 
feel frustrated when they can't run applications on a Java or .NET 
application server and notice that they have to set 
max_prepared_transactions and restart PostgreSQL.  This is far from 
friendly.

Regards
MauMau






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

Предыдущее
От: Mike Blackwell
Дата:
Сообщение: Re: Patch for reserved connections for replication users
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: strange behavior of pg_trgm's similarity function