Question about clustering multiple columns

From: "Benjamin Arai" <benjamin(at)araisoft(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Question about clustering multiple columns
Date: 2006-06-13 16:04:15
Message-ID: 002e01c68f03$05f00e10$6501a8c0@uni
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Hi,

I have a database where there are three columns (name,date,data). The
queries are almost always something like SELECT date,data FROM table WHERE
name=blah AND date > 1/1/2005 AND date < 1/1/2006;. I currently have three
B-tree indexes, one for each of the columns. Is clustering on date index
going to be what I want, or do I need a index that contains both name and
date?

Benjamin Arai
barai(at)cs(dot)ucr(dot)edu
http://www.benjaminarai.com <http://www.benjaminarai.com/>


Attachment Content-Type Size
barai@cs.ucr.edu.vcf text/x-vcard 710 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jqpx37 2006-06-13 16:07:54 PostgreSQL and Apache: authentication and authorization
Previous Message Martijn van Oosterhout 2006-06-13 15:47:14 Re: XID comparations

Browse pgsql-performance by date

  From Date Subject
Next Message Stephen Frost 2006-06-13 16:11:50 Re: Placement of 64-bit libraries (offtopic)
Previous Message Tom Lane 2006-06-13 14:36:59 Re: function not called if part of aggregate