Re: texteq/byteaeq: avoid detoast [REVIEW]

From: Noah Misch <noah(at)leadboat(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: texteq/byteaeq: avoid detoast [REVIEW]
Date: 2011-01-16 22:23:39
Message-ID: 20110116222339.GC4600@tornado.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Jan 16, 2011 at 01:05:11PM -0600, Andy Colson wrote:
> This is a review of:
> https://commitfest.postgresql.org/action/patch_view?id=468

Thanks!

> I created myself a more real world test, with a table with indexes and id's and a large toasted field.

> This will make about 600 records within the same xgroup. As well as a simple 'c15' type of value in c we can search for. My thinking is you may not know the exact unique id, but you do know what group its in, so that'll cut out 90% of the records, and then you'll have to add " and c = 'c15'" to get the exact one you want.

Good to have a benchmark like that, rather than just looking at the extrema.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Singer 2011-01-16 22:34:14 Re: Patch to add a primary key using an existing index
Previous Message Robert Haas 2011-01-16 22:20:52 Re: ALTER TYPE 0: Introduction; test cases