Re: BETWEEN optimizer problems with single-value

From: Simon Riggs
Subject: Re: BETWEEN optimizer problems with single-value
Date: ,
Msg-id: 1142538202.3859.513.camel@localhost.localdomain
(view: Whole thread, Raw)
In response to: Re: BETWEEN optimizer problems with single-value  (Alvaro Herrera)
List: pgsql-performance

Tree view

BETWEEN optimizer problems with single-value range  ("Kevin Grittner", )
 Re: BETWEEN optimizer problems with single-value range  (Andreas Kretschmer, )
  Re: BETWEEN optimizer problems with single-value  ("Kevin Grittner", )
   Re: BETWEEN optimizer problems with single-value  (Tom Lane, )
    Re: BETWEEN optimizer problems with single-value  ("Kevin Grittner", )
    Re: BETWEEN optimizer problems with single-value  (Simon Riggs, )
     Re: BETWEEN optimizer problems with single-value  (Simon Riggs, )
      Re: BETWEEN optimizer problems with single-value  (Tom Lane, )
       Re: BETWEEN optimizer problems with single-value  (Simon Riggs, )
        Re: BETWEEN optimizer problems with single-value  (Tom Lane, )
         Re: BETWEEN optimizer problems with single-value  (Simon Riggs, )
          Re: BETWEEN optimizer problems with single-value  (Alvaro Herrera, )
           Re: BETWEEN optimizer problems with single-value  (Simon Riggs, )
          Re: BETWEEN optimizer problems with single-value  (Tom Lane, )
           Re: BETWEEN optimizer problems with single-value  (Simon Riggs, )
 Re: BETWEEN optimizer problems with single-value range  ("Merlin Moncure", )
  Re: BETWEEN optimizer problems with single-value range  (Andreas Kretschmer, )
   Re: BETWEEN optimizer problems with single-value range  ("Merlin Moncure", )
 Re: [HACKERS] BETWEEN optimizer problems with single-value range  (Simon Riggs, )
  Re: [HACKERS] BETWEEN optimizer problems with single-value  ("Kevin Grittner", )

On Thu, 2006-03-16 at 15:41 -0400, Alvaro Herrera wrote:
> Simon Riggs wrote:
>
> > [BTW how do you add new indexes to system tables? I want to add one to
> > pg_inherits but not sure where to look.]
>
> See src/include/catalog/indexing.h -- I don't remember if there's
> anything else that needs modification.

That was easy: many thanks!

Best Regards, Simon Riggs



pgsql-performance by date:

From: "Kevin Grittner"
Date:
Subject: Re: Background writer configuration
From: "Luke Lonergan"
Date:
Subject: Re: 1 TB of memory