Re: 8.4.1 ubuntu karmic slow createdb

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: 8.4.1 ubuntu karmic slow createdb
Дата
Msg-id 1260554319.2611.10.camel@jd-desktop.unknown.charter.com
обсуждение исходный текст
Ответ на Re: 8.4.1 ubuntu karmic slow createdb  (Nikolas Everett <nik9000@gmail.com>)
Ответы Re: 8.4.1 ubuntu karmic slow createdb
Список pgsql-performance
On Thu, 2009-12-10 at 20:38 -0500, Nikolas Everett wrote:
> In my limited experience ext4 as presented by Karmic is not db
> friendly.  I had to carve my swap partition into a swap partition and
> an xfs partition to get better db performance.  Try fsync=off first,
> but if that doesn't work then try a mini xfs.

Do not turn fsync off. That is bad advice. I would not suggest ext4 at
this point for database operations. Use ext3. It is backward compatible.

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

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

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: Load experimentation
Следующее
От: Nikolas Everett
Дата:
Сообщение: Re: 8.4.1 ubuntu karmic slow createdb