Archiwizowane November, 2014

November 26th, 2014 by depesz | Tags: , | 17 comments »

During my time with PostgreSQL I found some things that I love. I found some things that I hate (very little of them). And some things that I would like to get, but, so far, I don't have them. Of course, ...

On 25th of November, Tom Lane committed patch: Support arrays as input to array_agg() and ARRAY(SELECT ...). These cases formerly failed with errors about "could not find array type for data type". Now they yield arrays of the same element type and ...

On 11th of November, Fujii Masao committed patch: Add generate_series(numeric, numeric). Платон Малюгин Reviewed by Michael Paquier, Ali Akbar and Marti Raudsepp

November 22nd, 2014 by depesz | Tags: | No comments »

This is not about PostgreSQL, or programming, or even computers. It's about board game. Be warned.

On 7th of November, Alvaro Herrera committed patch: BRIN is a new index access method intended to accelerate scans of very large tables, without the maintenance overhead of btrees or other traditional indexes. They work by maintaining "summary" data about block ranges. ...

There are some cases where you might want to get your own copy of explain.depesz.com. You might not trust me with your explains. You might want to use it without internet access. Or you just want to play with it, ...

Uploaded new version to the server - straight from GitHub. There are two changes - one visible, and one not really. The invisible change, first, is one for people hosting explain.depesz.com on their own. As you perhaps know you can get ...