PPAS 9.1 Beta 1 has been released. So, I thought to write about it and New Features which are coming.

Best part of PPAS 9.1 is that it has all features of PostgreSQL 9.1, which I have already discribed in my series of 9.1. List is given below:

1. PostgreSQL Object Manipulation Features

2. New Replication and Recovery Features

3. Queries improvement of Core PostgreSQL 9.1

4. Updateable Views using INSTEADOF Trigger in PostgreSQL 9.1

5. Utility Operation Improvements

6. Upsert/Merge using Writeable CTE

7. New Functions/Improvement

8. Object Functions Improvement in PostgreSQL 9.1

9. Client Application Improvement in PostgreSQL 9.1

10. Asynchronous/Synchronous Replication

There are some other features in PostgreSQL 9.1. List of those Improvements/features is given below:

1. Unlogged Tables

2. FOREACH IN ARRAY in PL/pgSQL

3. Pl/Perl Improvement:

 Record type support
 Pl/perl array argument map to Perl Argument.
 Pl/perl Composite-type array to Perl Hash.</strong>


4. Pl/Python Improvement:

 Table Support in Pl/Python Function
 New Validator for Pl/Python
 SQL Exception handling in Pl/Python Exception Blocks
 Subtransactions in Pl/Python
 New Pl/Ptyhon functions for Quoting String (plpy.quote_ident, plpy.quote_literal, and plpy.quote_nullable)
 Traceback support for Plpython errors</strong><strong>
 Exception Handling in Python3</strong>

5. ECPG Improvements:

 WHERE CURRENT OF in Dynamic Cursor
 Double digit with percision of 15</strong>

6. Libpq Improvements:

client_encoding option in Connection
PQlibVersion() function for knowing Version of Library
 PQping and PQpingParams for knowing Server Status.

With Above Features, PPAS 9.1 has additional Features and Improvement, which users would like to have.

List of those Features is given below:

1.VPD (Virtual Private Database) Support 

2. Parition Syntax Support

CREATE TABLE employees
 (empno numeric(4,0),
 ename varchar(10),
 job varchar(9),
 hiredate timestamp,
 )
PARTITION BY RANGE (hiredate)
 (PARTITION ten_year_staff
 VALUES LESS THAN('01-JAN-2001'),
 (PARTITION five_year_staff
 VALUES LESS THAN('01-JAN-2006'),
 (PARTITION one_year_staff
 VALUES LESS THAN('01-JAN-2011'));

CREATE TABLE employees
 (empno numeric(4,0),
 ename varchar(10),
 job varchar(9),
 hiredate timestamp,
)
PARTITION BY RANGE (hiredate)
SUBPARTITION BY LIST (job)
(PARTITION ten_year_staff VALUES LESS THAN('01-JAN-2001)
(SUBPARTITION mgmt VALUES ('MANAGER', 'PRESIDENT'), SUBPARTITION sales VALUES ('SALESMAN', 'CLERK'), SUBPARTITION support VALUES ('ANALYST')),
(PARTITION five_year_staff VALUES LESS THAN('01-JAN-2006') (SUBPARTITION mgmt VALUES ('MANAGER', 'PRESIDENT'),
 SUBPARTITION sales VALUES ('SALESMAN', 'CLERK'),
SUBPARTITION support VALUES ('ANALYST')),
(PARTITION one_year_staff VALUES LESS THAN('01-JAN-2011')
(SUBPARTITION mgmt VALUES ('MANAGER', 'PRESIDENT'), SUBPARTITION sales VALUES ('SALESMAN', 'CLERK'), SUBPARTITION support VALUES ('ANALYST'));

etc.

3. HextoRaw and RAWToHEX function support

4. New Hint: ORDERED

5. Ref Cursor as OUT in Procedure and Functions

6. WHEVEVER SQLERROR Syntax Support

7. Advanced Server Performance

Improvement in Lock Management for Read and Write workloads with more CPUs
Index Advisor Support for Composite Indexes

8. New Catalog Views for Partition Table

9. OCI Function: OCIBreak() and OCIReset() for sever connections on Blocking and nonBlocking Mode.

I would be discussing about above features in coming Blogs. So, stay tune!

8 Comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s