Peter Geoghegan's blog
Musings on PostgreSQL, database technology in general, and software development
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:
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 ...
11 comments:
Sunday, March 23, 2014
What I think of jsonb
›
Unsurprisingly, there has been a lot of interest in the jsonb type , which made it into the upcoming 9.4 release of Postgres . I was initial...
6 comments:
‹
›
Home
View web version