Is there a benefit to CLUSTER when retrieving individual records?

From: Robert James <srobertjames(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Is there a benefit to CLUSTER when retrieving individual records?
Date: 2012-05-15 20:58:20
Message-ID: CAGYyBggTODCnEyj17dXL8ySr=aQ=ntwc++c5pB0gMxHHAt4ifA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I see how CLUSTER can speed up a range query (eg WHERE val < 30),
because it groups those records in contiguous pages.

What about where I'm only pulling one record back? Eg WHERE user_id =
100. Is there any benefit to a CLUSTER in that case? Is there
anything lost if I CLUSTER on a different index?

If my usage is: A large number of single record SELECTs based on
user_id, and a small number of range queries, usually based on val,
would I be best off CLUSTERing on val?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2012-05-15 21:02:24 Disadvantage to CLUSTER?
Previous Message Adrian Klaver 2012-05-15 20:50:54 Re: Analyze all from command line