Re: Testing Sandforce SSD

Поиск
Список
Период
Сортировка
От Greg Spiegelberg
Тема Re: Testing Sandforce SSD
Дата
Msg-id AANLkTimwAqzvWvSfscqDKJDG3Yod=6KQ6e0Xo+c+k6s=@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Testing Sandforce SSD  (Greg Smith <greg@2ndquadrant.com>)
Ответы Re: Testing Sandforce SSD
Re: Testing Sandforce SSD
Re: Testing Sandforce SSD
Список pgsql-performance
On Mon, Jul 26, 2010 at 1:45 PM, Greg Smith <greg@2ndquadrant.com> wrote:
Yeb Havinga wrote:
I did some ext3,ext4,xfs,jfs and also ext2 tests on the just-in-memory read/write test. (scale 300) No real winners or losers, though ext2 isn't really faster and the manual need for fix (y) during boot makes it impractical in its standard configuration.

That's what happens every time I try it too.  The theoretical benefits of ext2 for hosting PostgreSQL just don't translate into significant performance increases on database oriented tests, certainly not ones that would justify the downside of having fsck issues come back again.  Glad to see that holds true on this hardware too.


I know I'm talking development now but is there a case for a pg_xlog block device to remove the file system overhead and guaranteeing your data is written sequentially every time?

Greg

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Testing Sandforce SSD
Следующее
От: Gerald Fontenay
Дата:
Сообщение: Re: Strange explain on partitioned tables