Skip site navigation (1) Skip section navigation (2)

Re: Major features for 9.1

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 (view raw or flat)
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


In response to

pgsql-advocacy by date

Next:From: Pavel StehuleDate: 2011-04-01 19:50:16
Subject: Re: Major features for 9.1
Previous:From: Thom BrownDate: 2011-04-01 19:30:24
Subject: Re: Major features for 9.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group