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.
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 |