Re: [PERFORM] Question about clustering multiple columns

2006-06-22 Thread Benjamin Arai
Thanks! This exactly what I was looking for. Benjamin Arai [EMAIL PROTECTED] http://www.benjaminarai.com -Original Message- From: Bruno Wolff III [mailto:[EMAIL PROTECTED] Sent: Friday, June 16, 2006 11:56 AM To: Benjamin Arai Cc: pgsql-performance@postgresql.org Subject: Re: Question

Re: [PERFORM] Question about clustering multiple columns

2006-06-16 Thread Bruno Wolff III
On Tue, Jun 13, 2006 at 09:04:15 -0700, Benjamin Arai [EMAIL PROTECTED] wrote: 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

Re: [PERFORM] Question about clustering multiple columns

2006-06-16 Thread Bruno Wolff III
On Fri, Jun 16, 2006 at 11:11:59 -0700, Benjamin Arai [EMAIL PROTECTED] wrote: Hi, Thanks for the reply. I have one more question. Does it matter in which order that I make the index? Please keep replies copied to the lists so that other people can learn from and crontibute to the