September 22nd, 2015 by depesz | Tags: , , , , | Comments Off on Waiting for 9.6 – Allow per-tablespace effective_io_concurrency

On 8th of September, Alvaro Herrera committed patch: Allow per-tablespace effective_io_concurrency Per discussion, nowadays it is possible to have tablespaces that have wildly different I/O characteristics from others. Setting different effective_io_concurrency parameters for those has been measured to improve performance. Author: Julien Rouhaud Reviewed by: Andres ...

On 14th of July, Alvaro Herrera committed patch: psql: Show tablespace size in \db+ Fabrízio de Royes Mello

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

January 23rd, 2014 by depesz | Tags: , , , , , , , | Comments Off on Waiting for 9.4 – Tablespace changes

On 18th of January, Stephen Frost committed patch: Add ALTER TABLESPACE ... MOVE command This adds a 'MOVE' sub-command to ALTER TABLESPACE which allows moving sets of objects from one tablespace to another. This can be extremely handy and avoids a lot of ...