| 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: | Whole Thread | Raw Message | 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 |