Skip site navigation (1) Skip section navigation (2)

Re: cluster on conditional index?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Doug Hunley <doug(dot)hunley(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: cluster on conditional index?
Date: 2012-08-14 17:10:47
Message-ID: CAMkU=1yB0C7pZzk9tM2mAUB8RWHxnpoVLn28ZQ_uSE__uTZAcg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Aug 14, 2012 at 8:27 AM, Doug Hunley <doug(dot)hunley(at)gmail(dot)com> wrote:
> According to the docs on cluster:
> if you tend to access some data more than others, and there is an
> index that groups them together, you will benefit from using CLUSTER
>
> however, this doesn't address the situation where you have a
> conditional index.

It seems like it is not allowed.

jjanes=# create index on pgbench_accounts (aid) where bid=33;
jjanes=# cluster pgbench_accounts USING pgbench_accounts_aid_idx ;
ERROR:  cannot cluster on partial index "pgbench_accounts_aid_idx"

But I don't see a fundamental reason it can't be allowed, maybe
implementing that should be on the to-do list.

Cheers,

Jeff


In response to

Responses

pgsql-performance by date

Next:From: ktm@rice.eduDate: 2012-08-14 17:29:10
Subject: Re: cluster on conditional index?
Previous:From: Doug HunleyDate: 2012-08-14 15:27:18
Subject: cluster on conditional index?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group