Archiwizowane January, 2010

January 21st, 2010 by depesz | Tags: , , | 4 comments »

I've written 29 posts about new features in 8.5. And now core team decided to name it 9.0. Great. And now I have to make changes in all of these posts. Just kidding - change is simple - I just added ...

I'm quite happy user of Arch Linux. BUT... Recent upgrade changed Xorg to new version which requires HAL (Hardware Abstraction Layer). Problem: when HAL is turned on, it totally breaks my keyboard - generates extra "key presses" when using "special" keys - ...

I just checked, and apparently explain.depesz.com is online for over a year now. First plans was added on 2008-12-04 13:20:43+01. Since then there have been 3602 plans added, 770 of them were set to be private (not displayed on previous explains ...

Some time ago Josh Berkus wrote about possible changes in VACUUM FULL. Now these changes came to life. By now, I mean 6th of January, when Takahiro Itagaki committed his patch: Log Message: ----------- Support rewritten-based full vacuum as VACUUM FULL. Traditional VACUUM FULL was ...

On 19th of December Simon Riggs committed a patch that will quite likely be the single most-talked-about change in PostgreSQL 8.5: Log Message: ----------- Allow read only connections during recovery, known as Hot Standby. Enabled by recovery_connections = on (default) and forcing ...

On 18th of December Bruce Momjian committed very important, but relatively small, patch: Log Message: ----------- Install server-side language PL/pgSQL by default. There is no point in showing it, commit log tells all - basically from 8.5 on PL/pgSQL will be enabled by default ...

On 15th of December Tom Lane committed patch by Andrew Gierth (aka RhodiumToad), which adds interesting capability: Log Message: ----------- Support ORDER BY within aggregate function calls, at long last providing a non-kluge method for controlling the order in which values are fed to ...

Today small, but (at least for me) really useful patch. Committed on 15th of December by Robert Haas, and written by Itagaki Takahiro, this patch does: Log Message: ----------- Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics. This patch also removes buffer-usage ...

On 7th of December, Tom Lane committed patch by Jeff Davis that adds general exclusion constraints: Log Message: ----------- Add exclusion constraints, which generalize the concept of uniqueness to support any indexable commutative operator, not just equality. Two rows violate the exclusion constraint if ...

January 2nd, 2010 by depesz | Tags: , , , , | No comments »

Just recently I wrote about DO command in PostgreSQL 8.5, and now (since 29th of November) we have DO with PL/Perl support. Written by Joshua Tolley and committed by Tom Lane, the patch: Log Message: ----------- Add support for anonymous code blocks (DO blocks) ...