subject:"\[GENERAL\] _page_cost parameter with values < 1"

Re: [GENERAL] _page_cost parameter with values < 1

2017-07-20 Thread Tom Lane

Thomas Kellerer writes: > 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? That reduces these costs relative to

[GENERAL] _page_cost parameter with values < 1

2017-07-20 Thread Thomas Kellerer

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 -- Sent via pgsql-general mailing list