Обсуждение: PickSplit method of 2 columns ... error

Has anyone come across this error before?

LOG:  PickSplit method of 2 columns of index
'asset_position_lines_asset_cubespacetime_idx' doesn't support secondary
split

This is a multi-column GiST index on an integer and a cube (a data type
from the postgres cube extension module).

I traced the error to the gistUserPicksplit
<gistsplit_8c.html#ae6afe3060066017ec18f7d40d3f9de8> function in the
gistsplit.c ... I surmise that this method is called whenever a page
split is necessary.

So, I know when this error occurs, but I don't know why.

Thoughts anyone?
Cheers,
Kevin

--
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7

Phone: (250) 383-3022
Email: kneufeld@refractions.net

Split page algorithm was rewrited for 8.2 for multicolumn indexes and API for
user-defined pickSplit function was extended to has better results with index
creation. But GiST can interact with old functions - and it says about this.
That isn't mean some real problem or error - index will be the same as in 8.1,
not better.



Kevin Neufeld wrote:
> Has anyone come across this error before?
>
> LOG:  PickSplit method of 2 columns of index
> 'asset_position_lines_asset_cubespacetime_idx' doesn't support secondary
> split
>
> This is a multi-column GiST index on an integer and a cube (a data type
> from the postgres cube extension module).
>
> I traced the error to the gistUserPicksplit
> <gistsplit_8c.html#ae6afe3060066017ec18f7d40d3f9de8> function in the
> gistsplit.c ... I surmise that this method is called whenever a page
> split is necessary.
>
> So, I know when this error occurs, but I don't know why.
>
> Thoughts anyone?
> Cheers,
> Kevin
>

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

Teodor Sigaev <teodor@sigaev.ru> writes:
> Split page algorithm was rewrited for 8.2 for multicolumn indexes and API for
> user-defined pickSplit function was extended to has better results with index
> creation. But GiST can interact with old functions - and it says about this.
> That isn't mean some real problem or error - index will be the same as in 8.1,
> not better.

Perhaps that LOG message should be reduced to DEBUG1 or so.  It's not
like it's something the average user could fix for himself.

            regards, tom lane

Yes, thanx. This would be useful as some of our clients are getting
swamped (and confused) with these messages in the log files.

Cheers,
Kevin

Tom Lane wrote:
> Teodor Sigaev <teodor@sigaev.ru> writes:
>
>> Split page algorithm was rewrited for 8.2 for multicolumn indexes and API for
>> user-defined pickSplit function was extended to has better results with index
>> creation. But GiST can interact with old functions - and it says about this.
>> That isn't mean some real problem or error - index will be the same as in 8.1,
>> not better.
>>
>
> Perhaps that LOG message should be reduced to DEBUG1 or so.  It's not
> like it's something the average user could fix for himself.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

--
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7

Phone: (250) 383-3022
Email: kneufeld@refractions.net