Re: The results of my PostgreSQL/filesystem performance tests

Поиск
Список
Период
Сортировка
От Sean Chittenden
Тема Re: The results of my PostgreSQL/filesystem performance tests
Дата
Msg-id 20030828214940.GQ83759@perrin.nxad.com
обсуждение исходный текст
Ответ на Re: The results of my PostgreSQL/filesystem performance tests  (Vivek Khera <khera@kcilink.com>)
Список pgsql-performance
> >> I need to step in and do 2 things:
> SC> Thanks for posting that.  Let me know if you have any questions while
> SC> doing your testing.  I've found that using 16K blocks on FreeBSD
> SC> results in about an 8% speedup in writes to the database, fwiw.
>
> ok.. ignore my prior request about how to set that... i missed you
> had included a patch.
>
> Any recommendations on newfs parameters for an overly large file
> system used solely for Postgres?  Over 100Gb (with raid 10) or over
> 200Gb (with raid 5)?

Nope, you'll have to test and see.  If you find something that works,
however, let me know.  -sc

--
Sean Chittenden

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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Queries sometimes take 1000 times the normal time
Следующее
От: Ken Geis
Дата:
Сообщение: bad estimates / non-scanning aggregates