clustering by partial indexes
| От | Keith C. Perry |
|---|---|
| Тема | clustering by partial indexes |
| Дата | |
| Msg-id | 1131487000.43711f18128c4@webmail.vcsn.com обсуждение исходный текст |
| Ответы |
Re: clustering by partial indexes
|
| Список | 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
В списке pgsql-general по дате отправления: