Search Postgresql Archives

TSearch: CLUSTER using GIST, query using GIN?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Does it make any sense to CLUSTER by a GIST index to move tuples with similar lexems physically closer together on disc, drop it and use GIN for the actual queries?

My queries are bound by HDD seek speed currently, might the above help me or can it even be counterproductive?


--
Best regards,
Hannes Dorbath

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux