On 28th of April, Greg Stark committed patch: Add support for wrapping to psql’s "extended" mode. This makes it very feasible to display tables that have both many columns and some large data in some columns (such as pg_stats). Emre Hasegeli with review and rewriting from Sergey Muraviov and reviewed by Greg Stark
On 13th of April, Tom Lane committed patch: Provide moving-aggregate support for a bunch of numerical aggregates. First installment of the promised moving-aggregate support in built-in aggregates: count(), sum(), avg(), stddev() and variance() for assorted datatypes, though not for float4/float8. In passing, remove a 2001-vintage kluge in interval_accum(): interval array elements have been … Continue reading “Waiting for 9.4 – Provide moving-aggregate support for a bunch of aggregates.”
Portuguese Brazil Version On 23rd of March, Andrew Dunstan committed patch: Introduce jsonb, a structured format for storing json. The new format accepts exactly the same data as the json type. However, it is stored in a format that does not require reparsing the orgiginal text in order to process it, making it much … Continue reading “Waiting for 9.4 – Introduce jsonb, a structured format for storing json.”
On 4th of March, Alvaro Herrera committed patch: auto_explain: Add logging of trigger execution Author: Kyotaro HORIGUCHI Reviewed-by: Jaime Casanova
On 4th of March, Alvaro Herrera committed patch: Constructors for interval, timestamp, timestamptz Author: Pavel Stěhule, editorialized somewhat by Álvaro Herrera Reviewed-by: Tomáš Vondra, Marko Tiikkaja With input from Fabrízio de Royes Mello, Jim Nasby
On 3rd of March, Robert Haas committed patch: Introduce logical decoding. This feature, building on previous commits, allows the write-ahead log stream to be decoded into a series of logical changes; that is, inserts, updates, and deletes and the transactions which contain them. It is capable of handling decoding even across changes to the … Continue reading “Waiting for 9.4 – Introduce logical decoding”
On 27th of February, Alvaro Herrera committed patch: Allow BASE_BACKUP to be throttled A new MAX_RATE option allows imposing a limit to the network transfer rate from the server side. This is useful to limit the stress that taking a base backup has on the server. pg_basebackup is now able to specify a … Continue reading “Waiting for 9.4 – Allow BASE_BACKUP to be throttled”
On 22nd of February, Peter Eisentraut committed patch: pg_basebackup: Add support for relocating tablespaces Tablespaces can be relocated in plain backup mode by specifying one or more -T olddir=newdir options. Author: Steeve Lennmark Reviewed-by: Peter Eisentraut
On 29th of January, Robert Haas committed patch: Include planning time in EXPLAIN ANALYZE output. This doesn’t work for prepared queries, but it’s not too easy to get the information in that case and there’s some debate as to exactly what the right thing to measure is, so just do this for now. … Continue reading “Waiting for 9.4 – Include planning time in EXPLAIN ANALYZE output.”
On 29th of January, Andrew Dunstan committed patch: Add json_array_elements_text function. This was a notable omission from the json functions added in 9.3 and there have been numerous complaints about its absence. Laurence Rowe.