Re: How to improve insert speed with index on text column

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How to improve insert speed with index on text column
Дата
Msg-id 4F2BDB160200002500044D5A@gw.wicourts.gov
обсуждение исходный текст
Список pgsql-performance
Saurabh  wrote:

> wal_buffers = 5MB

As as already been suggested, use 16MB (or if the version you're
using supports it, the default of -1);

> autovacuum = off

If the only activity while this is off is a bulk load, that might be
OK, but be sure *not* to leave this off.  You will almost certainly
regret very much later.  Your tables will tend to bloat and slowly
get very slow and very big.  At that point it will be much more
painful to do aggressive maintenance to clean things up.  If you
think you have some particular reason to turn it off, please discuss
it here -- you might have better options.

-Kevin


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: wal_level=archive gives better performance than minimal - why?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: How to improve insert speed with index on text column