Postgres Pro
Downloads
Home   >   mailing lists

TSearch: CLUSTER using GIST, query using GIN? - Mailing list pgsql-general

From Hannes Dorbath
Subject TSearch: CLUSTER using GIST, query using GIN?
Date
Msg-id fmsvq2$ti5$1@news.hub.org
Whole thread Raw
Responses Re: TSearch: CLUSTER using GIST, query using GIN?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: WARNINGs after starting backup server created with PITR
Next
From: "Sue Fitt"
Date:
Subject: turning off notices