On Tue, Nov 15, 2005 at 08:41:06PM -0500, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > Well, currently you can only cluster on a single index per table, and I
> > really doubt that will change. In any case, if someone's going to work
> > on clustered indexes I think it would be much more worthwhi
Jim C. Nasby wrote:
> On Tue, Nov 15, 2005 at 10:18:26AM -0800, Steve Crawford wrote:
> > Not trivial? Seems to me more like impossible to implement for the
> > general case which would require you to resolve the situation where
> > someone requests multiple, overlapping, clustered partial indexe
On Tue, Nov 15, 2005 at 10:18:26AM -0800, Steve Crawford wrote:
> Not trivial? Seems to me more like impossible to implement for the
> general case which would require you to resolve the situation where
> someone requests multiple, overlapping, clustered partial indexes
> where the ordering requ
On Tuesday 15 November 2005 10:12, Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> CLUSTER says "order the table according to the order of the
> >> entries in this index". A partial index doesn't define an
> >> ordering for the whole table, only the rows that have entries in
> >>
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> CLUSTER says "order the table according to the order of the entries in
> >> this index". A partial index doesn't define an ordering for the whole
> >> table, only the rows that have entries in that index. So it doesn't
> >> seem to
Bruce Momjian writes:
> Tom Lane wrote:
>> CLUSTER says "order the table according to the order of the entries in
>> this index". A partial index doesn't define an ordering for the whole
>> table, only the rows that have entries in that index. So it doesn't
>> seem to me that you are asking for
Tom Lane wrote:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
> > Quoting Tom Lane <[EMAIL PROTECTED]>:
> >> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
> >>> This might have been discussed before but I wanted to know if clustering
> >>> tables by partial indexes will be availble in a later relea
"Keith C. Perry" <[EMAIL PROTECTED]> writes:
> Quoting Tom Lane <[EMAIL PROTECTED]>:
>> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
>>> 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?
>>
>> What i
Quoting Tom Lane <[EMAIL PROTECTED]>:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
> > 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?
>
> What in the world would it mean to do that?
I'm not
"Keith C. Perry" <[EMAIL PROTECTED]> writes:
> 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?
What in the world would it mean to do that?
regards, tom lane
-
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 define
11 matches
Mail list logo
