Postgres Pro
Downloads
Home   >   mailing lists

Re: CLUSTER on 2 indexes ? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: CLUSTER on 2 indexes ?
Date
Msg-id dcc563d11002150913v2c18f74ep32c57d4a78214611@mail.gmail.com
Whole thread Raw
In response to CLUSTER on 2 indexes ?  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
List pgsql-general
Tree view 
On Mon, Feb 15, 2010 at 9:47 AM, Joao Ferreira gmail
<joao.miguel.c.ferreira@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...

You could have a multi-column index

pgsql-general by date:

Previous
From: Joao Ferreira gmail
Date:
Subject: CLUSTER on 2 indexes ?
Next
From: Scott Marlowe
Date:
Subject: Re: Multiple Server Installation/Design Question.