Re: PostgreSQL block size for SSD RAID setup? - Mailing list pgsql-performance

From henk de wit
Subject Re: PostgreSQL block size for SSD RAID setup?
Date
Msg-id COL104-W385B37179EFD710F5419C0F5AC0@phx.gbl
Whole thread Raw
In response to Re: PostgreSQL block size for SSD RAID setup?  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-performance
>You might also be interested in:
>
> http://thunk.org/tytso/blog/2009/02/20/aligning-filesystems-to-an-ssds-erase-block-size/
>
> http://thunk.org/tytso/blog/2009/02/22/should-filesystems-be-optimized-for-ssds/

Thanks a lot for the pointers. I'll definitely check these out.

> It seems you have to do more work than just look at the application. You want
> the application, the filesystem, the partition layout, and the raid device
> geometry to all consistently maintain alignment with erase blocks.

So it seems. PG is just a factor in this equation, but nevertheless an important one.


See all the ways you can stay connected to friends and family

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: PostgreSQL block size for SSD RAID setup?
Next
From: Tom Lane
Date:
Subject: Re: full text search - dictionary caching