Joe Van Dyk <joe@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance