> Gist indexes take a long time to create as compared
> to normal indexes is there any way to speed them up ?
> (for example by modifying sort_mem or something temporarily )

More sort_mem will indeed help.  So will more RAM and a faster CPU.

Our GIST-index-creation process is probably not optimized; this has been 
marked as "needs work" in the code for several versions.   If you know anyone 
who can help Oleg & Teodor out, be put them in touch ...


Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to