Blog: Peter Geoghegan


209 blogs updated: 10 min. ago
pg_hexedit: Rich hex editor annotations for Postgres relfiles
I've written an experimental tool for presenting PostgreSQL relation files in a hex editor with annotations/tags and tooltips that show the ...
0
27-11-2017 03:07:34 Peter Geoghegan PostgreSQL
amcheck "table-matches-index" enhancement now available, detects "freeze-the-dead" corruption
I'm pleased to announce that v1.2 of amcheck, a tool for detecting that PostgreSQL relations are logically consistent (that they do not appe...
0
26-10-2017 18:31:16 Peter Geoghegan PostgreSQL
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...
0
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...
0
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...
15
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...
24
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 ...
21
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.