Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] _page_cost parameter with values < 1 - Mailing list pgsql-general

From Thomas Kellerer
Subject [GENERAL] _page_cost parameter with values < 1
Date
Msg-id okq5kk$7bt$1@blaine.gmane.org
Whole thread Raw
Responses Re: [GENERAL] _page_cost parameter with values < 1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hello,

recently I have seen a Postgres configuration with the following values:

  seq_page_cost = 0.5
  random_page_cost = 0.6

Is there any advantage (or maybe disadvantage) compared to using e.g. 1.0 and 1.2?

Regards
Thomas

pgsql-general by date:

Previous
From: Dmitry Lazurkin
Date:
Subject: Re: [GENERAL] Planner statistics usage for composite type
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] How to stop array_to_json from interpolating column names that weren't there