Re: pgsql: Reorder 9.3 release note items

On 21 April 2013 05:57, Bruce Momjian <bruce@momjian.us> wrote:

> Reorder 9.3 release note items

A few corrections, additions and clarifications.

Corrections

* Allow recovery.conf to be relocated using configuration variable
recovery_config_directory
Patch was revoked...

* Need to mention the fast promote feature for standbys, which allows
us to skip shutdown checkpoint, reducing failover time from minutes to
seconds in busier databases

* Correct predicate locking for DROP INDEX CONCURRENTLY - bugfix not a feature

* Allow CREATE TABLE to succeed for a non-existent schema - should say
CREATE TABLE IF NOT EXISTS in that para and the one below it

* Previously functions already run in the current session ignored
changes (what does that mean?? missing text)

* Improve memory usage for in-memory sorts - IMHO this should read
"Allow in-memory sorts to use their full memory allocation", which
then explains why users may see higher memory usage and why they
should think about altering settings

Additions

* I think it would be useful to say that pg_upgrade is now much faster
because of the aggregate effect of the individual optimisations
mentioned in the performance section.

* "Require superuser privileges to set commit_delay"
Meaning of commit_delay has changed and users should review their
settings, if used

* Add isolation tests for CREATE INDEX CONCURRENTLY - Abhijit Menon-Sen


More info required...

* Need to say why Pavan's work on VACUUM is related to performance

* Need to say what effect Andres' patch to make HOT work on catalog
tables will have

* "Restructure WAL files to use a more compact storage format" - begs
the question how much more compact?

* Restructure WAL files to better handle timeline changes during
recovery - need to explain "better"

Thanks

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services