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

PostgreSQL Index

Top 40 Highest Paying URL Shortener Companies - Best URL Shorteners To Earn Fast

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

How to CreateYour Own AWS Account Alias?

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