(9.1) btree_gist support for searching on "not equals"
in [PgSql]
|
Prev: patch: to_string, to_array functions
Next: [HACKERS] WIP patch: pass outer-relation Vars as parameters to indexscans
From: Robert Haas on 3 Aug 2010 15:16 On Mon, Aug 2, 2010 at 11:16 PM, Jeff Davis <pgsql(a)j-davis.com> wrote: > On Mon, 2010-08-02 at 12:27 -0400, Robert Haas wrote: >> I was also wondering if it would be worth adding some additional >> regression testing to contrib/btree_gist exercising this new >> functionality. �Thoughts? > > Sure. I attached two tests. Committed. I renamed the test to "not_equals" rather than "mixed" and added an "EXPLAIN (COSTS OFF)" in there to verify that the index is actually being used. (I might have to remove that if it turns out not to be stable between an index scan and a bitmap index scan, but let's see what the buildfarm says.) -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Tom Lane on 3 Aug 2010 15:52 Robert Haas <robertmhaas(a)gmail.com> writes: > On Mon, Aug 2, 2010 at 11:16 PM, Jeff Davis <pgsql(a)j-davis.com> wrote: >> Sure. I attached two tests. > Committed. I see no sign of a commit from here ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Robert Haas on 3 Aug 2010 15:53
On Tue, Aug 3, 2010 at 3:52 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: > Robert Haas <robertmhaas(a)gmail.com> writes: >> On Mon, Aug 2, 2010 at 11:16 PM, Jeff Davis <pgsql(a)j-davis.com> wrote: >>> Sure. I attached two tests. > >> Committed. > > I see no sign of a commit from here ... Sigh. Forgot to exit my editor. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |