You're right, brain fart. Nevermind! :) On Sat, Nov 7, 2015 at 4:00 PM, Tom Lane <[email protected]> wrote:
> Joe Van Dyk <[email protected]> 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 >
