On 3rd of August, Tatsuo Ishii committed patch by ITAGAKI Takahiro: Log Message: ———– Multi-threaded version of pgbench contributed by ITAGAKI Takahiro, reviewed by Greg Smith and Josh Williams. Following is the proposal from ITAGAKI Takahiro: Pgbench is a famous tool to measure postgres performance, but nowadays it does not work well because … Continue reading “Waiting for 8.5 – Multi-threaded pgbench”
Robert Haas wrote, and Tom Lane committed (on 2nd of August) patch which adds interesting capability: Log Message: ———– Add ALTER TABLE … ALTER COLUMN … SET STATISTICS DISTINCT Robert Haas Log message is rather terse, so what does it exactly do?
On 1st of August Tom Lane committed patch from Itagaki Takahiro: Improve unique-constraint-violation error messages to include the exact values being complained of. In passing, also remove the arbitrary length limitation in the similar error detail message for foreign key violations. Itagaki Takahiro and later added an extension to it: Department of second … Continue reading “Waiting for 8.5 – better messages for unique violation”
On 29th of July ( I know, there is a long backlog in waiting for 8.5 series. I’m working on it :), Tom Lane committed patch by Dean Rasheed: Support deferrable uniqueness constraints. The current implementation fires an AFTER ROW trigger for each tuple that looks like it might be non-unique according to the … Continue reading “Waiting for 8.5 – deferrable uniqueness”
On 205h of July Andrew Dunstan committed patch by Andres Freund : Log Message: ———– DROP IF EXISTS for columns and constraints. Andres Freund.
Also yesterday, and also Peter Eisentraut, committed patch by Guillaume Smet, which: Add log_line_prefix placeholder %e to contain the current SQL state Author: Guillaume Smet
Yesterday Peter Eisentraut committed a patch, written by Damien Clochard, that modifies \d output in psql: Have \d show child tables that inherit from the specified parent As per discussion, \d shows only the number of child tables, because that could be hundreds, when used for partitioning. \d+ shows the actual list. Author: … Continue reading “Waiting for 8.5 – Have \d show child tables that inherit from the specified parent”
Everybody wrote that 8.4 was released, so it’s not a news now. But. Starting from yesterday, my own PostgreSQL reports it’s version like this: # select version(); version ———————————————————————————————————– PostgreSQL 8.5devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.4 (Ubuntu 4.2.4-1ubuntu4), 32-bit (1 row) Which means: I can start new blog posts series.
For quite some time I’ve been posting about new features in 8.4. First post was over a year ago, on 16th of February 2008. Now, we just (yesterday) got nice surprise: beta is here: (depesz@[local]:5840) 12:39:15 [depesz] # select version(); version ———————————————————————————————————– PostgreSQL 8.4beta1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.4 (Ubuntu 4.2.4-1ubuntu3), 32-bit … Continue reading “Waiting for 8.4 – final post (?)”
Usually I write about new features in 8.4, but this time I’d like to write about feature that will be actually missing in 8.4. And thank God, it will be missing. On Mon, 09 Mar 2009 11:22:47 -0400 Greg Sabino Mullane wrote mail to pgsql-hackers list with his patch that removes -d switch from pg_dump. … Continue reading “Waiting for 8.4 – no more -d in pg_dump!”