EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

PostgreSQL Features

Home » Data Science » Data Science Tutorials » PostgreSQL Tutorial » PostgreSQL Features

PostgreSQL Features

Introduction to PostgreSQL Features

PostgreSQL supports tremendous features that will make things easier. Some of the features are widely appreciated as they are incredibly useful. The following section contains some of the well-known features of PostgreSQL that you should look at as they will help you to improve performance in production and will make operations easier.

Features of PostgreSQL

Features provided by PostgreSQL are:

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

  • The multi-version concurrency control (MVCC) feature is implemented by PostgreSQL at the very first. In Oracle, the multi-version concurrency control (MVCC) feature is termed as snapshot isolation.
  • PostgreSQL is one of the advanced open-source databases, It offers many advantages for your company or business over other database systems. PostgreSQL is an object-relational database management system.
  • Users can participate in the PostgreSQL community to post and share knowledge, doubts, and bugs. Users can develop or propose new modules to its community as its open-source database management system.
  • PostgreSQL has a wide variety of communities. Because of its own global community and various kinds of people, the development possibility is very high.
  • PostgreSQL supports various programming languages such as s C/C++, Python, Ruby, Perl, Open Database Connectivity (ODBC) and Tcl, etc which allows us to develop different custom functions.
  • SQL functions called ‘Stored Procedure’ can be used for a server environment.
  • PostgreSQL supports following standard procedural languages,
    • PL/pgSQL
    • PL/Tcl
    • PL/Perl
    • PL/Python
  • Extensibility is one of the key features of PostgreSQL. In PostgreSQL, we can create our own functional languages, data types, index types, etc.
  • If the user wants to enhance the part of the system then they can easily write a custom plugin to meet their requirements.
  • PostgreSQL has a very big active community to support various kinds of queries. Anyone can easily find the answers to the issues with PostgreSQL from the PostgreSQL’s community.
  • If anyone needs so many companies to offer PostgreSQL commercial support services.
  • PostgreSQL runs on various operating systems, like Windows, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Linux, etc. PostgreSQL is available for almost every operating system with the latest stable release.
  • PostgreSQL supports different storage like text, images, sounds, and videos, etc.
  • Users can run different web apps and dynamic websites as a LAMP stack option using PostgreSQL.
  • PostgreSQL is a highly fault-tolerant database because of its write-ahead logging mechanism.
  • As of PostgreSQL available under open source license its source code is freely available. Which allows user to use freely, modify, and implement it as per their business needs.
  • In geospatial data stores for location-based services and geographic information systems, we can use PostgreSQL as it supports geographic objects.
  • PostgresSQL is very easy to learn, users don’t need to go through rigorous training in order to use it.
  • For embedded and enterprise PostgreSQL uses low maintenance administration
  • Users can write and execute their own code on the PostgreSQL database server using the above standard procedural languages and it can be executed by These procedural languages.PostgreSQL supports the following non-standard procedural languages as well.
    • PL/PHP
    • PL/V8
    • PL/Ruby
    • PL/Java
  • PostgreSQL can be extended in various ways. Users can add the following new features.
    • Data types
    • Functions
    • Operators
    • Aggregate functions
    • Index methods
  • PostgreSQL supports a huge set of the SQL standard and offers various modern features. Similar to the various enterprise database management system the PostgreSQL offers advanced features, such as:
    • User-defined types
    • Table inheritance
    • Sophisticated locking mechanism
    • Foreign key referential integrity
    • Views, rules, subquery
    • Nested transactions (savepoints)
    • Asynchronous replication
    • Complex SQL queries
    • SQL Sub-selects
    • Transactions
    • Multiversion concurrency control (MVCC)
    • Streaming Replication (as of 9.0)
    • Hot Standby (as of 9.0)
    • PostgreSQL is compatible with many platforms with the help of various programming languages and middleware.
    • It offers a most sophisticated locking mechanism
    • Support for multi-version concurrency control
    • Mature Server-Side Programming Functionality
    • Compliant with the ANSI SQL standard
    • Full support for client-server network architecture
    • Log-based and trigger-based replication SSL
    • Standby server and high availability
    • Object-oriented and ANSI-SQL2008 compatible
    • PostgreSQL support for JSON, with the help of JSON the linking with other data stores like NoSQL, is possible as it acts as a federated hub for polyglot databases.
    • PostgreSQL supports different geographic data storage techniques:
    • PostGIS,
    • Key-Value Store,
    • DBLink
  • Postgre SQL supports ACID and Transaction
    • PostgreSQL supports ACID(Atomicity, Consistency, Isolation, Durability).
    • The transaction is a very small unit of a program and it may perform various low-level tasks.
    • In order to maintain accuracy, completeness, and data integrity, the transaction in a database system must be ACID which means it should maintain Atomicity, Consistency, Isolation, and Durability.
  • PostgreSQL supports various techniques of indexing.
    • Other than B+ tree index techniques the PostgreSQL provides various kinds of techniques.
    • GIN(Generalized Inverted Index), and GiST(Generalized Search Tree), are indexing techniques supported by PostgreSQL.
  • PostgreSQL supports a flexible search for full-text.
    • In order to search strings, a full-text search is available with the execution of vector manipulation and string search.
  • PostgreSQL supports replication with different types.
    • PostgreSQL supports various replication methods,
      • Streaming Replication,
      • Slony-I,
      • Cascading,
    • Following features are also supported by the latest PostgreSQL:
      • Native Microsoft Windows Server version
      • Tablespaces
      • Point-in-time recovery

Recommended Articles

This is a guide to PostgreSQL Features. Here we discuss the Introduction and Various Features of PostgreSQL. You may also look at the following articles to learn more –

  1. PostgreSQL WHERE Clause
  2. SQL Server vs PostgreSQL
  3. MongoDB vs PostgreSQL
  4. PostgreSQL Data Types
  5. Learn the Relational Database Advantages

PL SQL Training (4 Courses, 2+ Projects)

4 Online Courses

2 Hands-on Projects

17+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
PostgreSQL Tutorial
  • Basic
    • What is PostgreSQL
    • PostgreSQL Features
    • How to Install PostgreSQL
    • PostgreSQL Versions
    • PostgreSQL Architecture
    • PostgreSQL GUI
    • PostgreSQL Variables
    • PostgreSQL Data Types
    • PostgreSQL NOT NULL
    • PostgreSQL Integer
    • PostgreSQL Boolean
    • PostgreSQL NULLIF
    • PostgreSQL Administration
    • PostgreSQL Commands
    • PostgreSQL Operators
    • PostgreSQL IN Operator
  • Control Statement
    • PostgreSQL IF Statement
    • PostgreSQL if else
    • PostgreSQL CASE Statement
    • PostgreSQL LOOP
    • PostgreSQL For Loop
    • PostgreSQL While Loop
  • Joins
    • Joins in PostgreSQL
    • PostgreSQL Inner Join
    • PostgreSQL Outer Join
    • LEFT OUTER JOIN in PostgreSQL
    • PostgreSQL FULL OUTER JOIN
    • PostgreSQL LEFT JOIN
    • PostgreSQL Full Join
    • PostgreSQL Cross Join
    • PostgreSQL NATURAL JOIN
    • PostgreSQL UPDATE JOIN
  • Queries
    • PostgreSQL Queries
    • PostgreSQL WHERE Clause
    • PostgreSQL WITH Clause
    • PostgreSQL ORDER BY
    • PostgreSQL ORDER BY Random
    • PostgreSQL GROUP BY
    • PostgreSQL group_concat
    • PostgreSQL HAVING
    • PostgreSQL Recursive Query
  • Advanced
    • PostgreSQL Schema
    • Postgres List Schemas
    • PostgreSQL VARCHAR
    • Array in PostgreSQL
    • PostgreSQL DDL
    • PostgreSQL List Users
    • Postgres Default User
    • Postgres add user
    • PostgreSQL log_statement
    • PostgreSQL String Functions
    • PostgreSQL Compare Strings
    • PostgreSQL Text Search
    • PostgreSQL TEXT
    • PostgreSQL String Array
    • PostgreSQL Constraints
    • PostgreSQL UNIQUE Constraint
    • PostgreSQL INTERSECT
    • PostgreSQL Like
    • Cursors in PostgreSQL
    • PostgreSQL UNION ALL
    • Indexes in PostgreSQL
    • PostgreSQL Index Types
    • PostgreSQL REINDEX
    • PostgreSQL UNIQUE Index
    • PostgreSQL Clustered Index
    • PostgreSQL DROP INDEX
    • PostgreSQL DISTINCT
    • PostgreSQL FETCH
    • PostgreSQL RAISE EXCEPTION
    • PostgreSQL Auto Increment
    • Sequence in PostgreSQL
    • Wildcards in PostgreSQL
    • PostgreSQL Subquery
    • PostgreSQL Alias
    • PostgreSQL LIMIT
    • PostgreSQL Limit Offset
    • PostgreSQL LAG()
    • PostgreSQL Table
    • Postgres Show Tables
    • PostgreSQL Describe Table
    • PostgreSQL Lock Table
    • PostgreSQL ALTER TABLE
    • Postgres Rename Table
    • Postgres DROP Table
    • PostgreSQL Functions
    • PostgreSQL Math Functions
    • PostgreSQL Window Functions
    • Aggregate Functions in PostgreSQL
    • PostgreSQL Primary Key
    • Foreign Key in PostgreSQL
    • PostgreSQL Procedures
    • PostgreSQL Stored Procedures
    • PostgreSQL Views
    • PostgreSQL Materialized Views
    • Postgres Create View
    • PostgreSQL Triggers
    • PostgreSQL DROP TRIGGER
    • PostgreSQL Date Functions
    • PostgreSQL TO_DATE()
    • PostgreSQL Timestamp
    • PostgreSQL CURRENT_TIMESTAMP()
    • PostgreSQL Notify
    • PostgreSQL RANK()
    • PostgreSQL Select
    • PostgreSQL Average
    • PostgreSQL DATE_PART()
    • PostgreSQL EXECUTE
    • PostgreSQL COALESCE
    • PostgreSQL EXTRACT()
    • PostgreSQL Sort
    • PostgreSQL TO_CHAR
    • PostgreSQL Interval
    • PostgreSQL Number Types
    • PostgreSQL ROW_NUMBER
    • Alter Column in PostgreSQL
    • PostgreSQL Identity Column
    • PostgreSQL SPLIT_PART()
    • PostgreSQL CONCAT()
    • PostgreSQL replace
    • PostgreSQL TRIM()
    • PostgreSQL MAX
    • PostgreSQL DELETE
    • PostgreSQL Float
    • PostgreSQL OID
    • PostgreSQL log
    • PostgreSQL REGEXP_MATCHES()
    • PostgreSQL MD5 
    • PostgreSQL NOW()
    • PostgreSQL RANDOM
    • PostgreSQL round
    • PostgreSQL Trunc()
    • PostgreSQL TIME
    • PostgreSQL IS NULL
    • PostgreSQL CURRENT_TIME
    • PostgreSQL MOD()
    • Postgresql Count
    • PostgreSQL Datetime
    • PostgreSQL MIN()
    • PostgreSQL age()
    • PostgreSQL enum
    • PostgreSQL OR
    • PostgreSQL Wal
    • PostgreSQL NOT IN
    • PostgreSQL SET
    • PostgreSQL Current Date
    • PostgreSQL Compare Date
    • PostgreSQL SERIAL
    • PostgreSQL Database
    • PostgreSQL Clone Database
    • PostgreSQL Copy Database
    • PostgreSQL Restore Database
    • PostgreSQL DROP DATABASE
    • PostgreSQL ALTER DATABASE
    • Postgres DROP Database
    • Postgres Dump Database
    • PostgreSQL OFFSET
    • PostgreSQL GRANT
    • PostgreSQL COMMIT
    • PostgreSQL ROLLUP
    • PostgreSQL JSON
    • EXPLAIN ANALYZE in PostgreSQL
    • PostgreSQL Temporary Table
    • PostgreSQL cluster
    • PostgreSQL Replication
    • PostgreSQL Logical Replication
    • PostgreSQL flush privileges
    • PostgreSQL Tablespaces
    • CAST in PostgreSQL
    • PostgreSQL CTE
    • hstore in PostgreSQL
    • PostgreSQL DECODE()
    • PostgreSQL Vacuum
    • PostgreSQL EXCLUDE
    • Postgres Change Password
    • Postgres Delete Cascade
    • PostgreSQL EXCEPT
    • PostgreSQL Roles
    • PostgreSQL Link
    • PostgreSQL Partition
    • PostgreSQL column does not exist
    • PostgreSQL Log Queries
    • PostgreSQL escape single quote
    • PostgreSQL Query Optimization
    • PostgreSQL Character Varying
    • PostgreSQL Transaction
    • PostgreSQL Extensions
    • PostgreSQL Import CSV
    • PostgreSQL Client
    • PostgreSQL caching
    • PostgreSQL JDBC Driver
    • PostgreSQL Interview Questions
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - PL SQL Training (4 Courses, 2+ Projects) Learn More