Blog: Peter Geoghegan

208 blogs updated: 76 min. ago
amcheck for Postgres 9.4+ now available from PGDG apt and yum repositories
amcheck, a tool for index corruption detection, now has packages available from the community Debian/Ubuntu apt repository, as well as packa...
16-10-2017 04:04:07 Peter Geoghegan PostgreSQL
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.