Re: Guessing future postgresql features

["Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com>]

On Mon, Mar 31, 2008 at 7:02 PM, Rafael Martinez
<r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> wrote:
>  * Auto-tuning / auto-configuration

Perhaps.  Though, people have been saying they were going to do it
since 2001, and yet nothing substantial exists.

>  * Easy update-in-place - 'pgmigrator'

This should be upgrade-in-place, not update-in-place

>  * More SQL99 and SQL2003 features

Likely.

>  * Update-in-place optimizations which enhance OLTP performance

Postgres does not have update-in-place.  I would just say OLTP
performance enhancements.

>  * Auto partitioning / Dynamic partitioning

Likely.

>  * External tables interfaces (SQL/MED compliant)

It would be nice to see distributed/federated code integrated into the
core, but I don't see it happening anytime soon.

>  * More exotic datatypes

Doubt it.

>  * More query optimizer improvements

Always

>  * Elimination of vacuum

I wish.

>  * Improve XML support

Probably.

>  * Pre-parsing phase that converts non-ISO syntax to supported syntax.

Doubtful.  That's a pgfoundry-type external project.

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/