Joe Van Dyk <joe@tanga.com> writes: > I noticed that querying for > product_attributes @> '{"upsell":["true"]}' > is much slower than querying for > product_attributes @> '{"upsell": 1}'
> Is that expected?
Your EXPLAIN results say that the first query matched 135843 rows and the second one none at all, so a significant variation in runtime doesn't seem that surprising to me ...