Hi,
I need an ANTI-JOIN (not exists SELECT something from table.../ left join table
WHERE table.id IS NULL) on the same table. Acutally I have an index to serve
the not exists question, but the query planner chooses to to a bitmap heap scan.
The table has 100 Mio rows, so doing a heap scan is
Thanks for the answer.
so there's no way around this problem? A nice index bitmap merge thing would be
super fast. Big table ANTI JOIN queries with only a few results expected, are
totally broken, if this is true.
This way the query breaks my neck. This is a massive downside of postgres which