Re: Major features for 9.1

From: phb07
Subject: Re: Major features for 9.1
Date: ,
Msg-id: 4D96DB18.8040101@apra.asso.fr
(view: Whole thread, Raw)
In response to: Re: Major features for 9.1  (Guillaume Lelarge)
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, )

Hi all,

I realize that by chance my choices are exactly the same as Guillaume's list !
So no need to repeat  ;-) . Just count +2 !
And I fully agree with his comments too.

Regards.
Philippe Beaudoin.



Guillaume Lelarge a écrit :
> Le 01/04/2011 21:21, Josh Berkus a écrit :
>
>> 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
> Not my personal favorite feature in 9.1, but it's one that people will
> notice.
>
>
>> * 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.
>>
>>
>
> +1
>
>
>> * SSI: Serializable Snapshot Isolation
>> True serializability without locking.  Eliminate a lot of SELECT FOR
>> UPDATE code.
>> This might also be a PostgreSQL first.
>>
>> * 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
> One of my two personal favorites features in 9.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.
>>
>> * Single-command cloning, new admin tools for replication
>> Not sure about this one, should probably be buried in text somewhere.
>>
>>
>
> +1 (but I would better say "Better administration and monitoring
> features for replication")
>
>
>> * PL/Python Overhaul
>> Not sure what went into this, can anyone give me details?
>>
>> * SEPostgres
>> SE-Postgres has been integrated into PostgreSQL through generic security
>> hooks and a contrib module.  Allows "military" level security/control
>> over database.
>>
>> * 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
> The other one of my two personal favorites features in 9.1.
>
>
>> Ones I don't think are major features but are cool anyway:
>>
>> * Valid-on-creation FKs
>> * Checkpoint Goggles
>> * Extensible ENUMs
>> * Triggers on Views
>> * New Trigram implementation (text is similar to ...)
>> * Reduced NUMERIC size
>>
>>
>
>
>


pgsql-advocacy by date:

From: Andrew Lardinois
Date:
Subject: Re: Theme for release
From: Robert Bernier
Date:
Subject: Re: Major features for 9.1