PostgreSQL Features
PostgreSQL supports a large part of the SQL standard and offers many modern features including the following:
1.SQL -structured query language
11.Postgresql Monitoring
12. Objects Max Sizes:
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
- 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
- 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
Post a Comment