Re: pageinspect: Hash index support
Ashutosh Sharma <ashu.coek88@gmail.com>
From: Ashutosh Sharma <ashu.coek88@gmail.com>
To: Jesper Pedersen <jesper.pedersen@redhat.com>
Cc: Jeff Janes <jeff.janes@gmail.com>,
Michael Paquier <michael.paquier@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2016-09-21T12:55:00Z
Lists: pgsql-hackers
Hi, > git apply w/ v4 works here, so you will have to investigate what happens on > your side. > Thanks, It works with v4 patch. > As these functions are marked as superuser only it is expected that people > provides the correct input, especially since the raw page structure is used > as the input. Well, page_stats / page_items does accept bitmap page as input but these function are not defined to read bitmap page as bitmap page doesnot have a standard page layout. Infact if we pass bitmap page as an input to page_stats / page_items, the output is always same. I think we need to have a separete function to read bitmap page. And i am not sure why should a server crash if i pass meta page to hash_page_stats or hash_page_items. > The "if" statement will need updating once the CHI patch goes in, as it > defines new constants for page types. Not sure if CHI patch is adding a new type of hash page other than holding an information about split in progress. Basically my point was can we have hash page of types other than meta page, bucket page, overflow and bitmap page. If pageinspect tool finds a page that doesnot fall under any of these category shouldn't it error out. With Regards, Ashutosh Sharma EnterpriseDB: http://www.enterprisedb.com
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