Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres on SSD - Mailing list pgsql-general

From Amitabh Kant
Subject Re: Postgres on SSD
Date
Msg-id CAPTAQBLSx9m5tJvupZBLzX0YBJ0oNpf-K7Vw_cJTqm0vqZoa0A@mail.gmail.com
Whole thread Raw
In response to Re: Postgres on SSD  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
Responses Re: Postgres on SSD  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
List pgsql-general
Tree view
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.ivanic@gmail.com>
Hi,

2011/8/10 Tomas Vondra <tv@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.ivanic@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

pgsql-general by date:

Previous
From: Håvard Wahl Kongsgård
Date:
Subject: Re: Convert mysql to postgresql
Next
From: Siva Palanisamy
Date:
Subject: Copy command to handle view for my export requirement