Re: Postgres on SSD

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)