Re: Major features for 9.1 - Mailing list pgsql-advocacy

From Pavel Stehule
Subject Re: Major features for 9.1
Date
Msg-id AANLkTim8dH6eK+yVZRb56NmE1M8miWqusTezcK=Odoba@mail.gmail.com
Whole thread Raw
In response to Major features for 9.1  (Josh Berkus <josh@agliodbs.com>)
List pgsql-advocacy
Hello

2011/4/1 Josh Berkus <josh@agliodbs.com>:
> 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
>
> * 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?
>

+1

> * Per-column collations
> Reason: fully multilingual databases now possible.
> This has been a TODO for a decade.
>

+1

> * SSI: Serializable Snapshot Isolation
> True serializability without locking.  Eliminate a lot of SELECT FOR
> UPDATE code.
> This might also be a PostgreSQL first.
>

+1

> * 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

I am thinking so 9.1 is little bit blurred - The most cool feature
highly depends on user group - PostGIS (KNN-GiST), ETL (unlogged
tables), in europe we like collations, developers will like wCTE, and
Java and Hibernate people will like SSI. A border is too wide. I like
SQL/MED but I am thinking, so this needs more time and as minimim is
real support for other SQL servers - this feature isn't completed now,
SEPostgres needs lot of love from people who work on distributions. I
don't know anybody, who can use this feature.


> Ones I don't think are major features but are cool anyway:
>
> * Valid-on-creation FKs
> * Checkpoint Goggles
> * Extensible ENUMs
> * Triggers on Views

-1

> * New Trigram implementation (text is similar to ...)

it is good marketing feature :) - same is functional dependency for
GROUP BY clause.



> * Reduced NUMERIC size

-1

I like all features - but not all can be mayor :)

Pavel

>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
> --
> Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-advocacy
>

pgsql-advocacy by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Major features for 9.1
Next
From: Guillaume Lelarge
Date:
Subject: Re: Major features for 9.1