| 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: | Whole Thread | Raw Message | 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 |