[GENERAL] GIN vs GIST multicolumn index

2012-07-30 Thread Oleg Mürk
index takes 4x more space. Is this an expected behavior or how can I speed up GIN index speed? (or reduce GIST index size?) P.S. Probably bitmap indexes would have been the best option. Thank You! Oleg Mürk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

[GENERAL] Picksplit warning

2012-05-08 Thread Oleg Mürk
Hello, Our postgresql logs are getting filled with warnings: LOG: picksplit method for column COLUMN_IDX of index INDEX_NAME doesn't support secondary split We are using gist indexes on integer, timestamp, and Postgis geometry. Is there a way to work around this problem? Thank You, Oleg