random_page_cost = 4.0
seq_page_cost = 1.0
There is about 500,000 rows and about 500 new rows each business day.
About 96% of rows meet given conditions, that is, count shoud be about 480,000.
BR,
Grzegorz Olszewski
Date: Tue, 27 May 2014 14:14:21 -0700
Subject: Re: [PERFORM] Planner doesn't
OK, thank you very much. I've tried similar query but with very few rows
matching. In this case index was present in the plan.
BR,
Grzegorz Olszewski
Date: Wed, 28 May 2014 08:31:38 -0500
From: stho...@optionshouse.com
To: grzegorz.olszew...@outlook.com; rumman...@gmail.com
CC: pgsql
x86_64
Best regards,
Grzegorz Olszewski