Re: GiST or GIN, I feel like I am doing something wrong

Aaron <aaron@chasingnuts.com> 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