| From: | Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | CLUSTER on 2 indexes ? |
| Date: | 2010-02-15 16:47:19 |
| Message-ID: | 1266252439.6763.6.camel@ubuntu8 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
Considering the CLUSTER operation on a frequently updated table, if I
have 2 indexes on the table how do I choose one of them ? or is it
possible to have CLUSTER take both into consideration...
my table is read from based on two columns: a 'timestamp' integer column
(actually a UTC integer timestamp) and a text columun called 'var' that
separates raw data from each other... something like a 'product type' in
a wharehouse example.
All queries that read from the table specify a time range and also the
'product type'. I have indexes on both.
Evidently no CLUSTERing should be worse than clustering on any of them,
but is there a way to have the two or choose the most profitable ?
thanks
Joao
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-02-15 17:13:33 | Re: CLUSTER on 2 indexes ? |
| Previous Message | Andre Lopes | 2010-02-15 16:25:57 | Re: Hosting Account with PostgreSQL and PHP? |