Andrew Gierth (RhodiumToad on irc) wrote, and Tom Lane committed: Assorted improvements in contrib/hstore. Remove the 64K limit on the lengths of keys and values within an hstore. (This changes the on-disk format, but the old format can still be read.) Add support for btree/hash opclasses for hstore — this is not so much … Continue reading “Waiting for 8.5 – changes in hstore”
After very long discussions, on 10th of August, Tom Lane committed patch by Robert Haas: Log Message: ———– Extend EXPLAIN to support output in XML or JSON format. There are probably still some adjustments to be made in the details of the output, but this gets the basic structure in place. Robert Haas
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”
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
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 (?)”
A long overdue post about new functionality. At this moment it is no longer such new, as it was committed on 28th of December (yes, I know, I should have written it earlier, Sorry). On this day Tom Lane committed patch by Hitoshi Harada which adds support for so called window functions: Support window functions … Continue reading “Waiting for 8.4 – window functions”
On 4th of January, Tom Lane committed patch by Takahiro Itagaki, which adds new contrib module – pg_stat_statements: Log Message: ———– Add contrib/pg_stat_statements for server-wide tracking of statement execution statistics. Takahiro Itagaki
On 4th of December Peter Eisentraut committed patch by Pavel Stehule (with Peters tweaks) which adds default values for function arguments: Default values for function arguments Pavel Stehule, with some tweaks by Peter Eisentraut