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
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 |