Re: [PERFORM] Query not using Index

2016-03-27 Thread Wei Shan
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

Re: [PERFORM] Query not using Index

2016-03-27 Thread Jeff Janes
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