You're right, brain fart. Nevermind! :) On Sat, Nov 7, 2015 at 4:00 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Joe Van Dyk <j...@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 ... > > regards, tom lane >