Aaron <aaron@xxxxxxxxxxxxxxx> writes: > CREATE INDEX profile_images_fulltext_gin ON profile_images_fulltext > USING gin(content); > CREATE INDEX profile_images_fulltext_gist ON profile_images_fulltext > USING gist(content); What did you have maintenance_work_mem set to while you did this? GIST doesn't care, but GIN likes to have lots of workspace while building an index. I'm not entirely sure if small workspace only affects build time, or if it could result in a bloated/inefficient index ... but if the latter is true it might explain your results. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
