Peter Geoghegan's blog
Musings on PostgreSQL, database technology in general, and software development
Tuesday, May 10, 2016
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: https://...
Saturday, November 14, 2015
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 migh...
2 comments:
Friday, October 2, 2015
Avoid naming a constraint directly when using ON CONFLICT DO UPDATE
›
PostgreSQL 9.5 will have support for a feature that is popularly known as "UPSERT" - the ability to either insert or update a row ...
Saturday, April 4, 2015
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...
3 comments:
‹
›
Home
View web version