On Tue, Aug 9, 2016 at 10:46 PM, Suya Huang <shu...@connexity.com> wrote: > Hi Claudio, > > Here is the index definition > "idx_data_3" gin (name gin_trgm_ops), tablespace "tbs_data" > "idx_data_4" gin (displayname gin_trgm_ops), tablespace "tbs_data"
GIN indexes are quite big, they can be bigger than the data. Check their size, it's possible that you can't fit data + indexes on those 2GB. But if prod is going to be bigger, prehaps it's a non-issue for you? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
