Re: Query not using Index - Mailing list pgsql-performance

From Jeff Janes
Subject Re: Query not using Index
Date
Msg-id CAMkU=1yoZ8g6ozqpSmY_FyhmcPkUCwOGRhoQBp4BR6uFzB3ogQ@mail.gmail.com
Whole thread Raw
In response to Re: Query not using Index  (Wei Shan <weishan.ang@gmail.com>)
List pgsql-performance
On Sun, Mar 27, 2016 at 9:12 AM, Wei Shan <weishan.ang@gmail.com> wrote:
> Hi Andreas,
>
> The tablespace is not on SSD although I intend to do it within the next
> week. I actually tried reducing the random_page_cost to 0.2 but it doesn't
> help.

Setting random_page_cost to less than seq_page_cost is nonsensical.

You could try to increase cpu_tuple_cost to 0.015 or 0.02


Cheers,

Jeff


pgsql-performance by date:

Previous
From: Wei Shan
Date:
Subject: Re: Query not using Index
Next
From: Chris Cogdon
Date:
Subject: Adding a ROLLUP switches to GroupAggregate unexpectedly