Re: BETWEEN optimizer problems with single-value

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: BETWEEN optimizer problems with single-value
Дата
Msg-id 1142539219.3859.517.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: BETWEEN optimizer problems with single-value  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Thu, 2006-03-16 at 14:45 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > [BTW how do you add new indexes to system tables? I want to add one to
> > pg_inherits but not sure where to look.]
>
> src/include/catalog/indexing.h
>
> Offhand I think adding a new entry is all you have to do.  You may also
> want a syscache to go with it, which'll take a bit more work.

I see its actually postgres.bki... I never scrolled to the bottom before
now.

I'll have a go.

Best Regards, Simon Riggs


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BETWEEN optimizer problems with single-value
Следующее
От: Theo Kramer
Дата:
Сообщение: Indexes with descending date columns