Re: [GENERAL] Future of PostgreSQL - Mailing list pgsql-general

From brent wood
Subject Re: [GENERAL] Future of PostgreSQL
Date
Msg-id 259D7B89B9AB3D1178D20005B823626F@brent.wood.blazemail.com
Whole thread Raw
List pgsql-general
My wish list has one major item, removal of the tuple/record limit.

This limit renders the spatial functionality as totally inadequate for any serious use. I like the approach in some
RDBMS'swhere there is a facility for "overflow" data, where the record size may have a basic limit, much as PostgreSQL
has,but additional data for a record (tuple) may be stored in secondary "volumes". Configuration of these limits is
ableto be adjusted dynamically by the DBA to suit the record structure & optimise for useage. 

Close to this in priority for my systems are referential integrity (esp foreign keys).

Some user control of index type would be nice also, not so much from a technical perspective, but a users: eg, a "time
series"style index where each attr is unique (typically incrementing) & an index suitable for bucket hits, where an
attris indexed but not unique. A good quad-tree would be nice for polygons too.... 

Summat that would be nice is a "user supplied code" site on the WWW somwhere. (I haven't been able to find such a
beast).Even some commercial software companies provide this type of servicefor users, full of disclaimers about the
contentsof course. 

EG: I may well want a user defined function as an addition to SQL functionality to return the distance between two
spatialentities (either cartesian or great circle). If there was a repository for such code I could just grab it, of it
itwasn't in the repository I could write & upload it...  

I believe that some of these are in the pipeline... Can't come too soon :-)



 Join AllAdvantage.com and get paid to surf the Web!
 Please use my ID (EIS-467) when asked if someone referred you. Thanks!
 http://www.alladvantage.com/go.asp?refid=EIS467

-------------------------
Get your own Free E-mail!
http://www.blazemail.com

pgsql-general by date:

Previous
From: "john huttley"
Date:
Subject: Re: [GENERAL] Future of PostgreSQL
Next
From: Kevin Lo
Date:
Subject: Re: [GENERAL] DBI::Pg for Perl?