Peter Geoghegan's blog

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

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...

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...

Friday, January 23, 2015

Abbreviated keys: exploiting locality to improve PostgreSQL's text sort performance

On Monday, Robert Haas committed a patch of mine that considerably speeds up the sorting of text in PostgreSQL. This was the last and the ...

View web version

About Me

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

Twitter: @petervgeoghegan

View my complete profile

Powered by Blogger.