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.
On 26 March 2016 at 22:13, Andreas Kretschmer
wrote:
> Wei Shan wrote:
>
> > Hi all,
> >
> > Please provide some advise on the fo
On Sun, Mar 27, 2016 at 9:12 AM, Wei Shan 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