Mallah, > 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 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