Re: btree gist known problems

Lists: pgsql-hackers
From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: btree gist known problems
Date: 2011-11-07 02:28:20
Message-ID: 1320632900.25188.46.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I'm looking for known problem areas in btree_gist. I see:

http://archives.postgresql.org/message-id/8973.1286841006@sss.pgh.pa.us

With Range Types, I'm anticipating that btree_gist will become more
important, so I'd like to know what bugs are holding it back.

So, anything else come to mind? Or does btree_gist just need a good
review? Or have the problems been fixed?

Regards,
Jeff Davis


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: btree gist known problems
Date: 2011-11-07 15:18:12
Message-ID: 24854.1320679092@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> I'm looking for known problem areas in btree_gist. I see:
> http://archives.postgresql.org/message-id/8973.1286841006@sss.pgh.pa.us

> With Range Types, I'm anticipating that btree_gist will become more
> important, so I'd like to know what bugs are holding it back.

> So, anything else come to mind? Or does btree_gist just need a good
> review? Or have the problems been fixed?

The thing I was complaining about in the referenced message is specific
to the inet opclass; it's unfair to make it sound like it's a generic
problem with btree_gist. And no, it's not been fixed AFAIK.

regards, tom lane


From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: btree gist known problems
Date: 2011-11-07 16:28:15
Message-ID: 1320683295.25188.64.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, 2011-11-07 at 10:18 -0500, Tom Lane wrote:
> Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> > I'm looking for known problem areas in btree_gist. I see:
> > http://archives.postgresql.org/message-id/8973.1286841006@sss.pgh.pa.us
>
> > With Range Types, I'm anticipating that btree_gist will become more
> > important, so I'd like to know what bugs are holding it back.
>
> > So, anything else come to mind? Or does btree_gist just need a good
> > review? Or have the problems been fixed?
>
> The thing I was complaining about in the referenced message is specific
> to the inet opclass; it's unfair to make it sound like it's a generic
> problem with btree_gist. And no, it's not been fixed AFAIK.

Sorry, I thought I remembered a few other comments but couldn't find
them in the archives. I must be mistaken.

Regards,
Jeff Davis