There have been several discussions for SSD in recent months although not specific to Fusion IO drives.
See http://archives.postgresql.org/pgsql-general/2011-04/msg00460.php . You can search the archives for more such reference. Amitabh 2011/8/11 Ondrej Ivanič <ondrej.iva...@gmail.com> > Hi, > > 2011/8/10 Tomas Vondra <t...@fuzzy.cz>: > > On 10 Srpen 2011, 1:17, Ondrej Ivanič wrote: > >> - What needs to be changed at Postgres/Operating system level? The > >> obvious one is to change random_page_cost (now: 2) and seq_page_cost > >> (now: 4). What else should I look at? > > > > Are you sure about this? I'm not quite sure setting seq_page_cost=4 and > > random_page_cost=2 makes sense. Usually seq_page_cost is lower than > > random_page_cost, so I wonder why have you set it like that. > > Ups! Well spotted Tomas! The actual values are: > random_page_cost = 2 > seq_page_cost = 1 > > -- > Ondrej Ivanic > (ondrej.iva...@gmail.com) > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
