Peter Geoghegan's blog

Musings on PostgreSQL, database technology in general, and software development

Friday, December 15, 2017

pg_hexedit now supports GiST, GIN, and hash indexes

I've added several enhancements to pg_hexedit, the experimental hex editor toolkit that allows you to open up raw PostgreSQL relation files with useful tags and annotations about the state and purpose of each field. The tool now supports annotations for GiST, GIN, and hash indexes, as well as sequences.

GIN "posting tree" leaf page. Compressed TIDs are in orange.
Read more »
at 12:29 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: index, internals, nbtree, postgresql
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

My photo
Peter Geoghegan
I'm a PostgreSQL Major Contributor and Committer.

Twitter: @petervgeoghegan
View my complete profile

Blog Archive

  • ►  2019 (1)
    • ►  March (1)
  • ►  2018 (3)
    • ►  May (1)
    • ►  March (1)
    • ►  January (1)
  • ▼  2017 (5)
    • ▼  December (1)
      • pg_hexedit now supports GiST, GIN, and hash indexes
    • ►  November (1)
    • ►  October (2)
    • ►  July (1)
  • ►  2016 (1)
    • ►  May (1)
  • ►  2015 (4)
    • ►  November (1)
    • ►  October (1)
    • ►  April (1)
    • ►  January (1)
  • ►  2014 (1)
    • ►  March (1)
  • ►  2013 (1)
    • ►  January (1)
  • ►  2012 (7)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  August (1)
    • ►  June (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2011 (3)
    • ►  August (1)
    • ►  July (2)
Simple theme. Theme images by Maliketh. Powered by Blogger.