Skip site navigation (1) Skip section navigation (2)

Re: Improvements to PostgreSQL

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Suresh Tri <trisuresh(at)yahoo(dot)co(dot)in>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Improvements to PostgreSQL
Date: 2004-07-26 07:27:41
Message-ID: 200407260927.41585.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Suresh Tri wrote:
> 2. Core functionality add-ons to postgresql :-
> -Table joins

Already done.

> -Java stored procedures

Already done.

> -Backup and recovery (incremental backup/restore)

Will appear in next release.

> -Query optimization
>   * Indexing techniques
>   * Star query optimization

Good luck with that. :-)

> - Data Types
>   * BLBL
>   * Images
>   * Long

These are probably redundant with bytea.

> 3. Application compatibility
> -Oracle Compatible JDBC driver

JDBC drivers should be compatible with the JDBC standard, not with some 
vendor.

> -Query compatibility
>   * Oracle DML/DDL Compatibility

Like what?

>   * Behavioral differences like null handling

Not gonna happen.

>   * Nested Queries

Do you mean recursive queries?

>   * Manual Optimization Hints

These are probably not going to be compatible with Oracle anyway.

> All your sugestions are welcome. Please help us to
> implement these features.
> Our aim is to make postgresql enterprise level.

PostgreSQL is already enterprise-level.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


In response to

Responses

pgsql-hackers by date

Next:From: Suresh TriDate: 2004-07-26 07:28:49
Subject: Stored procedures - Oracle vs postgresql
Previous:From: Simon RiggsDate: 2004-07-26 07:27:14
Subject: Re: CVS web interface error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group