PostgreSQL Features

PostgreSQL supports a large part of the SQL standard and offers many modern features including the following:
1.SQL -structured query language

• datatypes
• language
• constraints
• operators
• function
• joins
• subquery
• views
• synonym
• sequence

2.PL/pgSQL - procedural postgre structured query language 

• installing procedural language
• structure of Pl/pgSQL
• languages
• cursors
• exception
• procedure
• function
• triggers 

3.architecture

• fundamentals

4.installation

• GUI mode
• text mode
• unattended mode

5.database

• creating database
• accessing a database
• managing  roles,
• managing schema, 
• managing tablespace
• fragmentaion
• index
• lock management
• partition
• job

6.backup and restore

• dump
• filesystem level backup
• PITR

7.high availability

• Warm Standby Replication (as of 8.3)
• Streaming Replication (as of 9.0)
• Hot Standby (as of 9.0) 
• failover
• Monitorin Standby

8.database activity

• statistics collector
• viewing locks
• dynamic tracing
• disk usage
• disk full failure
• write-ahead logging (WAL)
• configuration

9.clinet interface

• libpq -c library
• large objects
• ECPG -empedded sql in c
• the information schema

10.Multiversion concurrency control (MVCC)

11.Postgresql Monitoring   

12. Objects Max Sizes:

• Maximum Database Size Unlimited
• Maximum Table Size 32 TB
• Maximum Row Size 1.6 TB
• Maximum Field Size 1 GB
• Maximum Rows per Table Unlimited
• Maximum Columns per Table 250 – 1600 depending on column types
• Maximum Indexes per Table Unlimited.