1. [Home](https://www.g2.com/)
2. ...
3. [Relational Databases](https://www.g2.com/categories/relational-databases)
4. [PostgreSQL Discussions](https://www.g2.com/products/postgresql/discuss)

[
 ![PostgreSQL](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_251be2af3ae607c45c14e816eaa1cf41/postgresql.png "PostgreSQL")
](/products/postgresql/reviews)

# PostgreSQL Discussions

PostgreSQL is a powerful, open-source object-relational database system renowned for its reliability, extensibility, and adherence to SQL standards. Originating from the POSTGRES project at the University of California at Berkeley in 1986, it has evolved over nearly four decades into a robust platform capable of handling complex data workloads across various operating systems. PostgreSQL's architecture emphasizes data integrity and scalability, making it a preferred choice for developers and organizations worldwide. Key Features and Functionality: - Comprehensive Data Types: Supports a wide range of data types, including primitives (Integer, Numeric, String, Boolean), structured (Date/Time, Array, Range), document (JSON/JSONB, XML), and geometric types. - Advanced Data Integrity: Ensures data accuracy through features like UNIQUE constraints, primary and foreign keys, exclusion constraints, and various locking mechanisms. - High Performance and Concurrency: Utilizes advanced indexing methods (B-tree, GiST, GIN, BRIN), a sophisticated query planner, multi-version concurrency control (MVCC), parallel query execution, and table partitioning to optimize performance. - Reliability and Disaster Recovery: Offers write-ahead logging (WAL), various replication methods (asynchronous, synchronous, logical), point-in-time recovery (PITR), and active standbys to ensure data durability and availability. - Robust Security Measures: Provides multiple authentication methods (GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, OAuth 2.0), a comprehensive access-control system, and supports multi-factor authentication. - Extensibility: Allows the creation of custom data types, functions, and operators. Supports procedural languages like PL/pgSQL, Perl, Python, and Tcl, with additional languages available through extensions. Primary Value and User Solutions: PostgreSQL addresses the needs of developers and organizations by offering a highly extensible and standards-compliant database system that ensures data integrity, scalability, and robust performance. Its open-source nature allows for continuous innovation and adaptability, enabling users to tailor the database to their specific requirements. Whether managing small applications or large-scale enterprise systems, PostgreSQL provides a reliable foundation for storing and processing data efficiently.

- **6** discussions

- ·

**83%** answered

- ·

**8** participants

 ![PostgreSQL](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_251be2af3ae607c45c14e816eaa1cf41/postgresql.png "PostgreSQL")

PostgreSQL Discussions

Most CommentedMost HelpfulCommon QuestionsNewest

Showing **6** discussions

 ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question")
G2

Pinned by G2 as a common question

•

about 3 years ago

More Options 
-  

Share

 

[![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=What+is+PostgreSQL+used+for%3F&title=What+is+PostgreSQL+used+for%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-postgresql-used-for)

[![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=What+is+PostgreSQL+used+for%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-postgresql-used-for&via=G2dotcom)

[![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-postgresql-used-for)

[![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=What+is+PostgreSQL+used+for%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-postgresql-used-for%0aWhat+is+PostgreSQL+used+for%3F)

[![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=What+is+PostgreSQL+used+for%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-postgresql-used-for%0aWhat+is+PostgreSQL+used+for%3F)

- 

Copy link

- 

[
## What is PostgreSQL used for?
](/discussions/what-is-postgresql-used-for)
What is PostgreSQL used for?

[

Relational Databases

](https://www.g2.com/tags/relational-databases)

Show More

 (Upvote this discussion)\<0\>0\> (Downvote this discussion)

1 (1 Comment)

Add a comment
[
View discussion
](/discussions/what-is-postgresql-used-for)

 ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question")
G2

Pinned by G2 as a common question

•

over 3 years ago

More Options 
-  

Share

 

[![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=What+is+special+about+PostgreSQL%3F&title=What+is+special+about+PostgreSQL%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-special-about-postgresql)

[![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=What+is+special+about+PostgreSQL%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-special-about-postgresql&via=G2dotcom)

[![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-special-about-postgresql)

[![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=What+is+special+about+PostgreSQL%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-special-about-postgresql%0aWhat+is+special+about+PostgreSQL%3F)

[![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=What+is+special+about+PostgreSQL%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-is-special-about-postgresql%0aWhat+is+special+about+PostgreSQL%3F)

- 

Copy link

- 

[
## What is special about PostgreSQL?
](/discussions/what-is-special-about-postgresql)
What is special about PostgreSQL?

[

Relational Databases

](https://www.g2.com/tags/relational-databases)

Show More

 (Upvote this discussion)\<0\>0\> (Downvote this discussion)

1 (1 Comment)

Add a comment
[
View discussion
](/discussions/what-is-special-about-postgresql)

 ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question")
G2

Pinned by G2 as a common question

•

over 4 years ago

More Options 
-  

Share

 

[![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=What+are+the+advantages+and+disadvantages+of+PostgreSQL%3F&title=What+are+the+advantages+and+disadvantages+of+PostgreSQL%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-are-the-advantages-and-disadvantages-of-postgresql)

[![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=What+are+the+advantages+and+disadvantages+of+PostgreSQL%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-are-the-advantages-and-disadvantages-of-postgresql&via=G2dotcom)

[![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-are-the-advantages-and-disadvantages-of-postgresql)

[![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=What+are+the+advantages+and+disadvantages+of+PostgreSQL%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-are-the-advantages-and-disadvantages-of-postgresql%0aWhat+are+the+advantages+and+disadvantages+of+PostgreSQL%3F)

[![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=What+are+the+advantages+and+disadvantages+of+PostgreSQL%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-are-the-advantages-and-disadvantages-of-postgresql%0aWhat+are+the+advantages+and+disadvantages+of+PostgreSQL%3F)

- 

Copy link

- 

[
## What are the advantages and disadvantages of PostgreSQL?
](/discussions/what-are-the-advantages-and-disadvantages-of-postgresql)
What are the advantages and disadvantages of PostgreSQL?

[

Relational Databases

](https://www.g2.com/tags/relational-databases)

Show More

 (Upvote this discussion)\<0\>0\> (Downvote this discussion)

2 (2 Comments)

Add a comment
[
View discussion
](/discussions/what-are-the-advantages-and-disadvantages-of-postgresql)

 ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question")
G2

Pinned by G2 as a common question

•

over 4 years ago

More Options 
-  

Share

 

[![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=What+programs+use+PostgreSQL%3F&title=What+programs+use+PostgreSQL%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-programs-use-postgresql)

[![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=What+programs+use+PostgreSQL%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-programs-use-postgresql&via=G2dotcom)

[![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-programs-use-postgresql)

[![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=What+programs+use+PostgreSQL%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-programs-use-postgresql%0aWhat+programs+use+PostgreSQL%3F)

[![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=What+programs+use+PostgreSQL%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fwhat-programs-use-postgresql%0aWhat+programs+use+PostgreSQL%3F)

- 

Copy link

- 

[
## What programs use PostgreSQL?
](/discussions/what-programs-use-postgresql)
What programs use PostgreSQL?

[

Relational Databases

](https://www.g2.com/tags/relational-databases)

Show More

 (Upvote this discussion)\<0\>0\> (Downvote this discussion)

1 (1 Comment)

Add a comment
[
View discussion
](/discussions/what-programs-use-postgresql)

 ![Shruti N.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Shruti N.")
SN

Loading...

[Shruti N.](https://www.g2.com/users/a8e4bc8e-a6e7-4f05-b2f5-35619f50dc54 "Shruti N.")

•

7 months ago

SEO Specialist

More Options 
-  

Share

 

[![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Getting+the+data+layer+right+early+on+can+save+a+lot+of+headaches+later.+From+my+experience+working+with+SEO+data%2C+even+smaller+projects+can+grow+quickly%2C+so...&title=Most+reliable+relational+database+software+for+new+businesses&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fmost-reliable-relational-database-software-for-new-businesses)

[![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=Most+reliable+relational+database+software+for+new+businesses&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fmost-reliable-relational-database-software-for-new-businesses&via=G2dotcom)

[![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fmost-reliable-relational-database-software-for-new-businesses)

[![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=Most+reliable+relational+database+software+for+new+businesses&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fmost-reliable-relational-database-software-for-new-businesses%0aGetting+the+data+layer+right+early+on+can+save+a+lot+of+headaches+later.+From+my+experience+working+with+SEO+data%2C+even+smaller+projects+can+grow+quickly%2C+so...)

[![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=Most+reliable+relational+database+software+for+new+businesses&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fmost-reliable-relational-database-software-for-new-businesses%0aGetting+the+data+layer+right+early+on+can+save+a+lot+of+headaches+later.+From+my+experience+working+with+SEO+data%2C+even+smaller+projects+can+grow+quickly%2C+so...)

- 

Copy link

- 

[
## Most reliable relational database software for new businesses
](/discussions/most-reliable-relational-database-software-for-new-businesses)

Getting the data layer right early on can save a lot of headaches later. From my experience working with SEO data, even smaller projects can grow quickly, so I’ve been...

[

Relational Databases Software

](https://www.g2.com/tags/relational-databases-software)

Show More

 (Upvote this discussion)\<0\>0\> (Downvote this discussion)

0 (0 Comments)

Add a comment
[
View discussion
](/discussions/most-reliable-relational-database-software-for-new-businesses)

 ![Jay P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Jay P.")
JP

Loading...

[Jay P.](https://www.g2.com/users/cac9ca71-4d84-4eeb-aee9-3bab4304371e "Jay P.")

•

almost 7 years ago

☁ Data Scientist (Big Data And Advanced Analytics) at FCA Fiat Chrysler Automobiles

More Options 
-  

Share

 

[![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=We+would+not+just+need+documentation+but+more+like+gifs+and+videos+to+explain+in+details&title=Can+we+get+some+video+tutorials+on+usage%3F+Also+how+do+we+connect+them+over+cloud+%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fcan-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud)

[![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=Can+we+get+some+video+tutorials+on+usage%3F+Also+how+do+we+connect+them+over+cloud+%3F&url=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fcan-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud&via=G2dotcom)

[![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fcan-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud)

[![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=Can+we+get+some+video+tutorials+on+usage%3F+Also+how+do+we+connect+them+over+cloud+%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fcan-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud%0aWe+would+not+just+need+documentation+but+more+like+gifs+and+videos+to+explain+in+details)

[![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=Can+we+get+some+video+tutorials+on+usage%3F+Also+how+do+we+connect+them+over+cloud+%3F&body=https%3A%2F%2Fwww.g2.com%2Fdiscussions%2Fcan-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud%0aWe+would+not+just+need+documentation+but+more+like+gifs+and+videos+to+explain+in+details)

- 

Copy link

- 

[
## Can we get some video tutorials on usage? Also how do we connect them over cloud ?
](/discussions/can-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud)
We would not just need documentation but more like gifs and videos to explain in details

[

Relational Databases Software

](https://www.g2.com/tags/relational-databases-software)

Show More

 (Upvote this discussion)\<0\>0\> (Downvote this discussion)

1 (1 Comment)

Add a comment
[
View discussion
](/discussions/can-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud)

## Browse by popular topics

[Relational Databases](/products/postgresql/discuss?filters%5Btags%5D%5B%5D=relational-databases)[Relational Databases Software](/products/postgresql/discuss?filters%5Btags%5D%5B%5D=relational-databases-software)