Re: index fragmentation on insert-only table with non-unique column

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: index fragmentation on insert-only table with non-unique column
Дата
Msg-id CACjxUsMS9zu=WT5TjoEwrb4v6rb-HNqSgA-WL7wsuxRbuR8Ttw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: index fragmentation on insert-only table with non-unique column  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
Дерево обсуждения 
On Fri, Jun 3, 2016 at 6:54 PM, Justin Pryzby <pryzby@telsasoft.com> wrote:

>  max_wal_size                | 4GB                 | configuration file
>  min_wal_size                | 6GB                 | configuration file

Just a minor digression -- it generally doesn't make sense to
configure the minimum for something greater than the maximum for
that same thing.  That should have no bearing the performance issue
raised on the thread, but you might want to fix it anyway.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Venkata Balaji N
Дата:
Сообщение: Re: pg_database_size
Следующее
От: Tom Lane
Дата:
Сообщение: Re: index fragmentation on insert-only table with non-unique column