Re: [GENERAL] How to avoid a GIN recheck condition

Thanks for your detailed answer ! I miss understood the query plan. Indeed the slowing down comes from my order clause, which I didn't include in my previous email. Still loving PostgreSQL from the first day <3 -- View this message in context: http://postgresql.nabble.com/How-to-avoid-a-GIN-r

Re: [GENERAL] How to avoid a GIN recheck condition

Alexis writes: > I have a GIN index but the planner rechecks the condition. When many rows > are foud in the index that is very slow: You're assuming a fact not in evidence, namely that the recheck condition is being used at runtime. The planner will *always* attach a recheck condition to a bitm