Blog: Peter Geoghegan

209 blogs updated: 6 min. ago
PostgreSQL Index bloat under a microscope
I've posted a snippet query to the PostgreSQL Wiki that "summarizes the keyspace" of a target B-Tree index. This means that it displays whic...
19-07-2017 09:00:51 Peter Geoghegan PostgreSQL
amcheck: Verify the logical consistency of PostgreSQL B-Tree indexes
I've created a project page on Github for amcheck, a tool for verifying the logical consistency of PostgreSQL B-Tree indexes: The tool is pr...
10-05-2016 21:04:47 Peter Geoghegan PostgreSQL
Suggesting a corrected column name/spelling in the event of a column misspelling
One small PostgreSQL 9.5 feature I worked on is the new hinting mechanism feature, which sometimes hints, based on a score, what you might h...
14-11-2015 15:25:00 Peter Geoghegan PostgreSQL
Abbreviated keys for numeric to accelerate numeric sorts
Andrew Gierth's numeric abbreviated keys patch was committed recently. This commit added abbreviation/sortsupport for the numeric type (the ...
04-04-2015 16:19:00 Peter Geoghegan PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.