Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group