PostgreSQL introduction, postgresql

Source: Internet
Author: User
Tags postgresql introduction

PostgreSQL introduction, postgresql
PostgreSQL Introduction: PostgreSQL is a relational database management system in the industry. It is applicable to various Linux operating systems, Windows, Solaris, BSD, and Mac OS X. PostgreSQL follows the BSD license and is an open-source software. As the fourth largest relational database service in the world, PostgreSQL is developing at a fast speed and is now widely used in various industries. What features does PostgreSQL have, please refer to the following link:
1. PostgreSQL database is currently the most powerful open-source database and the closest open-source database to Oracle in architecture. It basically contains all the functions you can find in other commercial or open-source databases. 2. closest to the industrial standard SQL92, new function compatible with the latest SQL standard: SQL2003, support SQL2011 main features see: http://www.postgresql.org/docs/9.4/interactive/features.html3. supports complex multi-table JOIN query SQL: The JOIN algorithm supports hash join and merge join. 4. Supports window functions and can be changed to complex analysis functions because the analysis functions include window functions. 5. The multi-process architecture is more stable. A single machine can support databases with higher access volumes. 6. There is a powerful and excellent performance GIS plug-in Postgis.
Our upcoming RDS for PostgreSQL not only has the features of native PostgreSQL, but also inherits the excellent features of RDS products. PostgreSQL will have the following features: Phase I plan: 1. the fully automated failover solution switches to the slave node in seconds when the master database fails. 2. Supports real-time synchronous replication to ensure the highest security of data. 3. Cross-zone migration is supported. 4. Collect, display, and alert a wide range of performance metrics. 5. Powerful security protection functions, including anti-DDOS and IP whitelist. ...... If you have any good ideas, you can give us feedback in a timely manner. Let's build the strongest PostgreSQL together.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.