Re: Major features for 9.1
От | Joshua D. Drake |
---|---|
Тема | Re: Major features for 9.1 |
Дата | |
Msg-id | 1301686441.2324.20.camel@jd-desktop обсуждение исходный текст |
Ответ на | Major features for 9.1 (Josh Berkus <josh@agliodbs.com>) |
Список | 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
В списке pgsql-advocacy по дате отправления: