[GENERAL] CLUSTER on 2 indexes ?

2010-02-15 Thread Joao Ferreira gmail
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

Re: [GENERAL] CLUSTER on 2 indexes ?

2010-02-15 Thread Scott Marlowe
On Mon, Feb 15, 2010 at 9:47 AM, Joao Ferreira gmail joao.miguel.c.ferre...@gmail.com wrote: 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...