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@xxxxxxxxx>
Hi,
2011/8/10 Tomas Vondra <tv@xxxxxxxx>:
> On 10 Srpen 2011, 1:17, Ondrej Ivanič wrote:Ups! Well spotted Tomas! The actual values are:
>> - 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.
random_page_cost = 2
seq_page_cost = 1
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
