Re: Postgres on SSD - Mailing list pgsql-general

From Tomas Vondra
Subject Re: Postgres on SSD
Date
Msg-id ac283c65fa43c60b9492d28ec8ce4c51.squirrel@sq.gransy.com
Whole thread Raw
In response to Postgres on SSD  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
Responses Re: Postgres on SSD
Re: Postgres on SSD
List pgsql-general
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.

Tomas


pgsql-general by date:

Previous
From: tamanna madaan
Date:
Subject: canceling autovacuum task error
Next
From: c k
Date:
Subject: Re: [ADMIN] postgresql server crash on windows 7 when using plpython