Re: pageinspect: Hash index support
Jesper Pedersen <jesper.pedersen@redhat.com>
From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: Jeff Janes <jeff.janes@gmail.com>,
Alvaro Herrera <alvherre@2ndquadrant.com>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2016-09-20T12:40:34Z
Lists: pgsql-hackers
Attachments
- 0001-pageinspect-Hash-index-support_v3.patch (text/x-patch)
On 09/20/2016 03:19 AM, Michael Paquier wrote: > You did not get right the comments from Alvaro upthread. The following > functions are added with this patch: > function hash_metap(text) > function hash_metap_bytea(bytea) > function hash_page_items(text,integer) > function hash_page_items_bytea(bytea) > function hash_page_stats(text,integer) > function hash_page_stats_bytea(bytea,integer) > > Now the following set of functions would be sufficient: > function hash_metapage_info(bytea) > function hash_page_items(bytea) > function hash_page_stats(bytea) > The last time pageinspect has been updated, when BRIN functions have > been added, it has been discussed to just use (bytea) as an argument > interface and just rely on get_raw_page() to get the pages wanted, so > I think that we had better stick with that and keep things simple. > Yes, I know, Alvaro and you voted for the bytea methods, and Jeff asked for both. Attached is v3 with only the bytea based methods. Alvaro, Michael and Jeff - Thanks for the review ! Best regards, Jesper
Commits
-
Fix incorrect typecast.
- b4316928d57b 10.0 landed
-
In pageinspect/hashfuncs.c, avoid crashes on alignment-picky machines.
- 14e9b18fed28 10.0 landed
-
pageinspect: Support hash indexes.
- 08bf6e529587 10.0 landed
-
Add uuid to the set of types supported by contrib/btree_gist.
- 11da83a0e70d 10.0 cited
-
Allow CREATE EXTENSION to follow extension update paths.
- 40b449ae84dc 10.0 cited