Re: Postgres on SSD

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(dot)ivanic(at)gmail(dot)com>

> Hi,
>
> 2011/8/10 Tomas Vondra <tv(at)fuzzy(dot)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(dot)ivanic(at)gmail(dot)com)
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>