News for hackers. Stuff that matters.

A comment on Running 10M PostgreSQL Indexes in Production. Parent comment

Re:Running 10M PostgreSQL Indexes in Production by kbaker on Tuesday June 13, 2017 @11:42AM (#14545627)
Just wondering if you looked into using GiN or GiST indexes on the JSON in the table?
[ Parent | on HN ]
Re:Running 10M PostgreSQL Indexes in Production by malisper on Tuesday June 13, 2017 @02:46PM (#14547456)
Yes, we have. The problem a lot of our keys and values are numeric. GIN/GiST only support equality for JSON fields. Additionally the GIN/GiST index winds up being significantly larger and is a bit slower than partial indexes.
[ Parent | on HN ]