Re: PostgreSQL block size for SSD RAID setup?

From: henk de wit <henk53602(at)hotmail(dot)com>
To: <stark(at)enterprisedb(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL block size for SSD RAID setup?
Date: 2009-02-25 16:13:34
Message-ID: COL104-W385B37179EFD710F5419C0F5AC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
http://www.microsoft.com/windows/windowslive/default.aspx

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-02-25 16:36:14 Re: full text search - dictionary caching
Previous Message Gregory Stark 2009-02-25 15:42:14 Re: PostgreSQL block size for SSD RAID setup?