From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: Major features for 9.1 |
Date: | 2011-04-01 19:34:01 |
Message-ID: | 1301686441.2324.20.camel@jd-desktop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
On Fri, 2011-04-01 at 12:21 -0700, Josh Berkus wrote:
> All,
>
> 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.
>
> The tough part is going to be picking 5-6 items from the below.
>
> * Synchronous Replication
> Reason: obvious
+1
>
> * wCTE: Writeable Common Table Expressions
> Reason: replace large amounts of app code with single queries.
> Also, we may be the first DB to have this. Anyone know?
>
> * Per-column collations
> Reason: fully multilingual databases now possible.
> This has been a TODO for a decade.
>
> * SSI: Serializable Snapshot Isolation
> True serializability without locking. Eliminate a lot of SELECT FOR
> UPDATE code.
> This might also be a PostgreSQL first.
-1 (it is a great feature but doesn't mean anything to the wider
"press")
>
> * Unlogged Tables
> Reason: allows using Postgres for not-valuable, high-performance data
> like session tables instead of using a caching database
+1
>
> * SQL/MED with FILE_FDW
> Reason: allows using PostgreSQL to query any kind of data source you can
> roll a driver for. First one shipping reads CSV files, eliminating the
> need to COPY them into the database in many cases.
>
+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
> * PL/Python Overhaul
> Not sure what went into this, can anyone give me details?
>
-1
> * SEPostgres
> SE-Postgres has been integrated into PostgreSQL through generic security
> hooks and a contrib module. Allows "military" level security/control
> over database.
>
+1
> * Extensions
> Optional PostgreSQL code, such as extra data types, GIS, languages, etc,
> can now be packaged as pluggable extensions, greatly simplifying
> installing and upgrading them. In addition, the PGXN network will
> become an online repository of these extensions.
>
+1
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-04-01 19:50:16 | Re: Major features for 9.1 |
Previous Message | Thom Brown | 2011-04-01 19:30:24 | Re: Major features for 9.1 |