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

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

Migrating From Oracle to PostgreSQL using ora2pg open source tools

7 Steps to configure BDR replication in postgresql