thx a lot for the reply. i will post the query plans when a new bulk insert
will take place :)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/manually-force-planner-to-use-of-index-A-vs-index-B-tp5044616p5044691.html
Sent from the PostgreSQL - performance mailing list ar
On 3.12.2011 15:34, MirrorX wrote:
>
> but, at some point there are some bulk inserts with a different date. when
> this happens and i run the query mentioned above the planner is using index
> A and not index B.
> i guess this happens b/c the planner due to the last analyze statistics has
> no va
hello to all,
the situation i am facing is this->
table X-> 200 mil rows
index A (date, columnA)
index B (date,columnB,columnC)
the query planner is working properly and for a specific query that selects
from table X where all 3 columns of index B are set, it uses index B.
but, at some point the
