TSearch: CLUSTER using GIST, query using GIN?

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: TSearch: CLUSTER using GIST, query using GIN?
Date: 2008-01-19 14:00:34
Message-ID: fmsvq2$ti5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2008-01-19 15:10:27 Re: TSearch: CLUSTER using GIST, query using GIN?
Previous Message Simon Riggs 2008-01-19 08:26:37 Re: WARNINGs after starting backup server created with PITR