Re: Major features for 9.1

From: Kevin Grittner
Subject: Re: Major features for 9.1
Date: ,
Msg-id: 4D95F4EF020000250003C161@gw.wicourts.gov
(view: Whole thread, Raw)
In response to: Major features for 9.1  (Josh Berkus)
Responses: Re: Major features for 9.1  (Florian Weimer)
List: pgsql-advocacy

Tree view

Major features for 9.1  (Josh Berkus, )
 Re: Major features for 9.1  (Thom Brown, )
 Re: Major features for 9.1  ("Joshua D. Drake", )
 Re: Major features for 9.1  (Pavel Stehule, )
 Re: Major features for 9.1  (Guillaume Lelarge, )
  Re: Major features for 9.1  (phb07, )
 Re: Major features for 9.1  ("Kevin Grittner", )
  Re: Major features for 9.1  (Florian Weimer, )
 Re: Major features for 9.1  (Robert Bernier, )
  Re: Major features for 9.1  (David Fetter, )
 Re: Major features for 9.1  (Simon Riggs, )
  Re: Major features for 9.1  (Josh Berkus, )
   Re: Major features for 9.1  (Simon Riggs, )
    Re: Major features for 9.1  (Gilberto Castillo Martínez<>, )
    Re: Major features for 9.1  (David Fetter, )
   Re: Major features for 9.1  (Peter Eisentraut, )
    Re: Major features for 9.1  (David Fetter, )
     Re: Major features for 9.1  (Peter Eisentraut, )
   Re: Major features for 9.1  (Peter Eisentraut, )
    Re: Major features for 9.1  (Joshua Berkus, )
     Re: Major features for 9.1  (Andrew Lardinois, )
     Re: Major features for 9.1  ("Kevin Grittner", )
     Re: Major features for 9.1  (David Fetter, )
     Re: Major features for 9.1  (Greg Smith, )
      Re: Major features for 9.1  (Joshua Berkus, )
      Re: Major features for 9.1  (Bruce Momjian, )
    Re: Major features for 9.1  (Gilberto Castillo Martínez<>, )
   Re: Major features for 9.1  (Joshua Berkus, )
    Re: Major features for 9.1  (Peter Eisentraut, )
    Re: Major features for 9.1  (Oleg Bartunov, )
 Re: Major features for 9.1  (Emanuel Calvo, )
 Re: Major features for 9.1  ("Kevin Grittner", )
 Re: Major features for 9.1  ("Kevin Grittner", )
  Re: Major features for 9.1  (Jeff Davis, )
   Re: Major features for 9.1  ("Kevin Grittner", )
    Re: Major features for 9.1  (Oleg Bartunov, )
     Re: Major features for 9.1  (Gilberto Castillo Martínez<>, )
    Re: Major features for 9.1  (Jeff Davis, )
     Re: Major features for 9.1  ("Kevin Grittner", )
 Re: Major features for 9.1  ("Kevin Grittner", )
  Re: Major features for 9.1  (Gilberto Castillo Martínez<>, )
   Re: Major features for 9.1  ("Kevin Grittner", )
    Re: Major features for 9.1  (Andrew Lardinois, )
     Re: Major features for 9.1  ("Kevin Grittner", )
      Re: Major features for 9.1  ("Kevin Grittner", )
       Re: Major features for 9.1  (Andrew Lardinois, )
        Re: Major features for 9.1  ("Kevin Grittner", )
         Re: Major features for 9.1  (Andrew Lardinois, )
     Re: Major features for 9.1  (Simon Riggs, )
 Re: Major features for 9.1  (Aidan Van Dyk, )
 Re: Major features for 9.1  ("Kevin Grittner", )
  Re: Major features for 9.1  (Nikolas Everett, )
  Re: Major features for 9.1  (Josh Berkus, )
   Re: Major features for 9.1  ("Kevin Grittner", )
  Re: Major features for 9.1  (Roy Hann, )
   Re: Major features for 9.1  (Jeff Davis, )
    Re: Major features for 9.1  (Peter Eisentraut, )
     Re: Major features for 9.1  ("Kevin Grittner", )
  Re: Major features for 9.1  (Roy Hann, )
   Re: Major features for 9.1  ("Kevin Grittner", )
    Re: Major features for 9.1  (Jeff Davis, )
     Re: Major features for 9.1  ("Kevin Grittner", )
 Re: Major features for 9.1  ("Kevin Grittner", )
 Re: Major features for 9.1  (Peter Eisentraut, )
  Re: Major features for 9.1  (Magnus Hagander, )
   Re: Major features for 9.1  (Peter Eisentraut, )
 Re: Major features for 9.1  ("Kevin Grittner", )
  Re: Major features for 9.1  ("Joshua D. Drake", )
  Re: Major features for 9.1  (Greg Smith, )
   Re: Major features for 9.1  ("Kevin Grittner", )
    Re: Major features for 9.1  (Greg Smith, )
     Re: Major features for 9.1  ("Kevin Grittner", )
 Re: Major features for 9.1  (Simon Riggs, )
  Re: Major features for 9.1  (Joshua Tolley, )
   Re: Major features for 9.1  (Gilberto Castillo Martínez<>, )
   Re: Major features for 9.1  (Thomas Kellerer, )

Josh Berkus <> wrote:

> * Synchronous Replication
> Reason: obvious

Gotta mention this, based on constantly expressed interest.

+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?

This is very cool, but I don't know how many people know enough
about CTEs to be impressed.

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

Not big for me, but I'll bet in certain countries or application
types it is huge.

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

Obviously *I* think it's big.  Besides the on-list posts, I've
gotten quite a few off-list emails and comments at conferences which
make me think there are a lot of others interested.  Notice the
aggressive testing it got once it hit alpha.  I'm pretty sure I'd
have heard about it or run across it in web searches if anybody else
had beat us to this.  (I would say that "without blocking" would be
more technically accurate than "without locking".)

+1

> * Unlogged Tables
> Reason: allows using Postgres for not-valuable, high-performance
> data like session tables instead of using a caching database

This will be very useful for our shop, but like CTEs, I don't know
how many people in the wider audience will be as impressed by this
as the other items.

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

I have no idea how big the audience is for this one.

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

This is very cool, although I don't think I'll have any use for it.
The audience may be smaller than for other features.

> * Single-command cloning, new admin tools for replication
> Not sure about this one, should probably be buried in text
> somewhere.

Agree on including in text but not major feature point.

> * PL/Python Overhaul
> Not sure what went into this, can anyone give me details?

As valuable as this is, an overhaul doesn't sound like a major
feature, on the face of it.

-1

> * SEPostgres
> SE-Postgres has been integrated into PostgreSQL through generic
> security hooks and a contrib module.  Allows "military" level
> security/control over database.

Clearly there is a lot of interest in certain quarters.  My concern
on pushing it as a major feature is that, given the nature of the
community which needs this, I suspect that those who really care
already know it's coming in 9.1, and those who don't already know
won't care so much.  (I could be wrong about that, though.)

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

That's big.

+1

-Kevin


pgsql-advocacy by date:

From: "Joshua D. Drake"
Date:
Subject: Re: Theme for release
From: Mike Ellsworth
Date:
Subject: Re: Theme for release