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 |
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 |
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 |