Postgres Plus® Advanced Server
v9.2 is now Generally Available
This latest release of the Oracle compatible open source based database server merges in all community PostgreSQL 9.2.1 features and fixes and contains our 9th generation of expanded Oracle compatibility support. Try the out the performance improvements of Index Only Scans, faster in-memory sorting, and INSERT append hints. Developers get support for productive data types like JSON and Range types.
| To buy call +1 781-357-3390 or 1-877-377-4352 (US Only) today! |  |
Postgres Plus Advanced Server offers enterprise features not available in the community edition of PostgreSQL. If you are looking for the absolute best in Security, Development, Ease of Use, Performance, Scalability, or Compatibility, with a TCO for any budget, and backed by world wide world class support, then you need Postgres Plus Advanced Server.
Supported Platforms
Postgres Plus Advanced Server 9.2.x is available today on Linux 32 and 64 bit platforms, Windows 32 and 64 bit platforms, HP-UX and Solaris. For more details see Platform Support by Version.
New v9.2 Feature Highlights:
Object Type support provides object oriented capabilities for developers. Users can create objects (complete with attributes, functions and procedures for manipulating data) that map directly into object types in other object oriented languages.
This hint when added to the INSERT command adds new rows to the end of the relation and skips using the Free Space Map to find available space within the relation. This will improve INSERT performance for tables that experience frequent record deletions and have less impact on tables that don't.
These are queries where results can be determined by looking at just the index, and not at the corresponding table thereby improving performance. For example, the query: SELECT COUNT(*) FROM mytable will no longer also scan mytable and return a result much quicker.
An improved sorting change yields upwards of a 20% improvement for in-memory sorts.
Views tagged with a security_barrier option cannot be moved into other scopes, preventing possible leakage of view-prohibited data. These views might perform more poorly than non-barrier views.
To view collection data using tools that require a conventional format, you must unnest, or flatten, the collection attribute of a row into one or more relational rows. A TABLE expression enables you to query a collection in the FROM clause like a table.
Download the Advanced Server data sheet here.
