Here's my thoughts...
> Here's a list of the features which seem to me to be major enough to be
> headliners for 9.1. Please mark which ones you think are major/not
> major/not major and anything you think I've forgotten.
>
> ... picking 5-6 items ...
> Synchronous Replication
+1
it's the flavour of the day
> * wCTE: Writeable Common Table Expressions
+1
I'm finding myself using a lot of Common Table Expressions it's more intuitive
than the more traditional BEGIN .. COMMIT paradigm especially for
programmers/developers
> * Per-column collations
-1
>
> * SSI: Serializable Snapshot Isolation
> True serializability without locking.
-1
You have to explain this otherwise there's no point in promoting this
> * Unlogged Tables
> Reason: allows using Postgres for not-valuable, high-performance data
> like session tables instead of using a caching database
+1
This is a sleeper. Drop the apology that it's for 'not-valuable' data. I can
see a lot of places that can allow pg to enter the big-data / cassandra /
hbase world
> * SQL/MED with FILE_FDW
+1
> * KNN-GiST: K-Nearest Neighbor Indexing
> Permits indexed searches of "what's near X", greatly improving the
> responsiveness of PostGIS applications and allowing new application
> types to be built.
-1
> * Single-command cloning, new admin tools for replication
> Not sure about this one, should probably be buried in text somewhere.
-1
Should be massaged as part of the continuing evolution of replication support,
the first point.
> * PL/Python Overhaul
-1
need more details to vote on it
> SEPostgres
-1
requires a user-case i.e. show how a past high profile exploit could have been
stopped with this mechanism in place.
> Extensions
+1
I suggest a user-case explanation of how would it be used