Re: slow update of index during insert/copy

Поиск
Список
Период
Сортировка
От Thomas Finneid
Тема Re: slow update of index during insert/copy
Дата
Msg-id 48C0E931.4080703@ifi.uio.no
обсуждение исходный текст
Ответ на Re: slow update of index during insert/copy  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-performance

Greg Smith wrote:
> In practice, the "ordered"
> mode (the default for ext3) seems sufficient to prevent database
> corruption. There is a substantial performance hit to running in full
> journal mode like you're doing;

where do you see which mode I am running in? I havent specified any
modes in any config or commands, so I am assuming its using ext3
defaults, which I am assuming is "ordered".

regards



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

Предыдущее
От: "David Wilson"
Дата:
Сообщение: Re: inaccurate stats on large tables
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: too many clog files