Re: Postgres on SSD - Mailing list pgsql-general

From Ondrej Ivanič
Subject Re: Postgres on SSD
Date
Msg-id CAM6mie+A4j4SUBv+g=KJzAZyTR4oQ5_EE3S7bcSj3E+2WTOmnw@mail.gmail.com
Whole thread Raw
In response to Re: Postgres on SSD  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: Postgres on SSD  (Amitabh Kant <amitabhkant@gmail.com>)
Re: Postgres on SSD  (Vick Khera <vivek@khera.org>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Re: Postgres on SSD
Next
From: Craig Ringer
Date:
Subject: Re: postgresql server crash on windows 7 when using plpython