clustering by partial indexes

From: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: clustering by partial indexes
Date: 2005-11-08 21:56:40
Message-ID: 1131487000.43711f18128c4@webmail.vcsn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This might have been discussed before but I wanted to know if clustering tables
by partial indexes will be availble in a later release of pgSQL?

For the record, this is the error I get in 8.1:

iprism=# cluster hrs_idx on report;
ERROR: cannot cluster on partial index "hrs_idx"

hrs_idx is defined as:

iprism=# \d hrs_idx
Index "public.hrs_idx"
Column | Type
--------+--------------------------
stamp | timestamp with time zone
btree, for table "public.report", predicate (thehour(stamp) >= 0::double
precision AND thehour(stamp) <= 23::double precision)

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message lh1101 2005-11-08 22:09:17 Transactions, Triggers and Error Messages
Previous Message Alex Mayrhofer 2005-11-08 21:39:52 Re: upgrading from backend version 811 to 812