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   

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.

Comments

Popular posts from this blog

Oracle DBMS SCHEDULER Examples

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

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

vacuumlo - removing large objects orphans from a database PostgreSQL