Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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      
          

Comments

Popular posts from this blog

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Postgres Database Patch

How to Enable/Disable autovacuum on PostgreSQL

PostgreSQL Enterprise Manager - PEM Monitoring Tools