Re: The results of my PostgreSQL/filesystem performance

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: The results of my PostgreSQL/filesystem performance
Дата
Msg-id 3F4EB738.1060203@potentialtech.com
обсуждение исходный текст
Ответ на Re: The results of my PostgreSQL/filesystem performance  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-performance
Christopher Kings-Lynne wrote:
>>>As with all performance tests/benchmarks, there are probably dozens or
>>>more reasons why these results aren't as accurate or wonderful as they
>>>should be.  Take them for what they are and hopefully everyone can
>>>learn a few things from them.
>>>
>>>Intelligent feedback is welcome.
>>>
>>>http://www.potentialtech.com/wmoran/postgresql.php
>>
>>I notice that the Linux FSs weren't tested with noatime.  Any
>>reason?
>
> My friend, (a FreeBSD committer), was wondering what the results are if you
> turn off softupdates (to match Linux default installation) and use noatime.

Keep an eye on the page.  The test results will be posted shortly after I
finish them.

Keep in mind, I'm more interested in figuring out what can be done to make
Postgres _faster_, so tests along that line are going to have a higher
priority than ones that specifically compare "apples to apples" or anything
like that.

> He also wonders how bug the default IO is?

Huh?

--
Bill Moran
Potential Technologies
http://www.potentialtech.com


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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: opinion on RAID choice
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: bad estimates / non-scanning aggregates