In One Minute : PostgreSQL

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.

PostgreSQL features transactions with ACID properties, automatically updatable views, materia…


This content originally appeared on DEV Community 👩‍💻👨‍💻 and was authored by Rakesh KR

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.

PostgreSQL features transactions with ACID properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures.
It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users.

PostgreSQL manages concurrency through multiversion concurrency control (MVCC), which gives each transaction a "snapshot" of the database, allowing changes to be made without affecting other transactions.

PostgreSQL provides an asynchronous messaging system that is accessed through the NOTIFY, LISTEN and UNLISTEN commands.

PostgreSQL includes built-in support for regular B-tree and hash table indexes, and four index access methods: generalized search trees (GiST), generalized inverted indexes (GIN), Space-Partitioned GiST (SP-GiST) and Block Range Indexes (BRIN).

Official website : https://www.postgresql.org/


This content originally appeared on DEV Community 👩‍💻👨‍💻 and was authored by Rakesh KR


Print Share Comment Cite Upload Translate Updates
APA

Rakesh KR | Sciencx (2022-10-19T18:23:24+00:00) In One Minute : PostgreSQL. Retrieved from https://www.scien.cx/2022/10/19/in-one-minute-postgresql/

MLA
" » In One Minute : PostgreSQL." Rakesh KR | Sciencx - Wednesday October 19, 2022, https://www.scien.cx/2022/10/19/in-one-minute-postgresql/
HARVARD
Rakesh KR | Sciencx Wednesday October 19, 2022 » In One Minute : PostgreSQL., viewed ,<https://www.scien.cx/2022/10/19/in-one-minute-postgresql/>
VANCOUVER
Rakesh KR | Sciencx - » In One Minute : PostgreSQL. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2022/10/19/in-one-minute-postgresql/
CHICAGO
" » In One Minute : PostgreSQL." Rakesh KR | Sciencx - Accessed . https://www.scien.cx/2022/10/19/in-one-minute-postgresql/
IEEE
" » In One Minute : PostgreSQL." Rakesh KR | Sciencx [Online]. Available: https://www.scien.cx/2022/10/19/in-one-minute-postgresql/. [Accessed: ]
rf:citation
» In One Minute : PostgreSQL | Rakesh KR | Sciencx | https://www.scien.cx/2022/10/19/in-one-minute-postgresql/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.