Re: [PERFORM] Postgres inconsistent use of Index vs. Seq Scan

2015-03-13 Thread Tom Lane
"Jim Carroll" writes: > I'm having difficulty understanding what I perceive as an inconsistency in > how the postgres parser chooses to use indices. We have a query based on NOT > IN against an indexed column that the parser executes sequentially, but > when we perform the same query as IN, it us

[PERFORM] Postgres inconsistent use of Index vs. Seq Scan

2015-03-13 Thread Jim Carroll
I'm having difficulty understanding what I perceive as an inconsistency in how the postgres parser chooses to use indices. We have a query based on NOT IN against an indexed column that the parser executes sequentially, but when we perform the same query as IN, it uses the index. I've created