| 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: | Whole Thread | Raw Message | 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
| 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? |