Re: CLUSTER on 2 indexes ?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CLUSTER on 2 indexes ?
Date: 2010-02-15 17:13:33
Message-ID: dcc563d11002150913v2c18f74ep32c57d4a78214611@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 15, 2010 at 9:47 AM, Joao Ferreira gmail
<joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-02-15 17:17:33 Re: Multiple Server Installation/Design Question.
Previous Message Joao Ferreira gmail 2010-02-15 16:47:19 CLUSTER on 2 indexes ?