Re: BETWEEN optimizer problems with single-value - Mailing list pgsql-performance

From Simon Riggs
Subject Re: BETWEEN optimizer problems with single-value
Date
Msg-id 1142539219.3859.517.camel@localhost.localdomain
Whole thread Raw
In response to Re: BETWEEN optimizer problems with single-value  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BETWEEN optimizer problems with single-value
Next
From: Theo Kramer
Date:
Subject: Indexes with descending date columns