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
On Sat, 19 Jan 2008, Hannes Dorbath wrote:
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
Oleg Bartunov wrote:
what do you want to speed up ? Search is very fast, see explain analyze.
The problem usually in the access to documents found to calculate
rank, headlines. If GIN returns N documents, then you need to read
all of them to calculate rank and here you get slowdown.
I don't