The effective_cache_size is one gig. The others are not set so therefore the default.
On Sun, Jan 25, 2015 at 6:08 AM, Sameer Kumar <sameer.kumar@xxxxxxxxxx> wrote:
On Fri, Jan 23, 2015 at 3:04 PM, Tim Uckun <timuckun@xxxxxxxxx> wrote:Adding some info on the query and table structure (and indexes) would be helpful here.I don't want to really force pg to always use the same index because in some cases this strategy would win but I am wondering if there is anything I need to do in order to get the planner to make better decisions.The final number of records is very small but PG is starting out with a massive number of records and then filtering most of them out.What are the values for below parameters-- random_page_cost- seq_page_cost- effective_cache_sizeI already did an analyze on the table.Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
