- Green versionView
- Green versionView
- Green versionView
- Green versionView
PostgreSQL software introduction
PostgreSQL software can run on a variety of operating system platforms, such as FreeBSD, Linux, and Mac OS X, Solaris, Windows, etc. At the same time, postgresql fully supports ACID features, which provides strong security guarantees for database access and makes full use of enterprise security tools, such as Kerberos and OpenSSL. You can define your own checks to ensure data quality based on your own business rules. Among the many management features, PITR is a great feature. It is a flexible high-availability feature that provides the ability to create hot backups and snapshots and restores for failure recovery.
PostgreSQL software features
1. Database
It has the most comprehensive free software database and the widest range of applications.
2. Processing
Transaction processing, subqueries, and multi-version concurrency control are always the only ones supported.
3. Inspection
It also features data integrity checks and free software database management systems.
4. Common
Supports the world’s most common data types. Some types of data are not even available in commercial databases.
PostgreSQL software features
Sustained performance
Based on previous PostgreSQL versions, PostgreSQ can effectively handle duplicate data in standard database index B-tree indexes. This reduces the overall space usage required by B-tree indexes while improving overall query performance.
PostgreSQL introduces incremental sorting, where sorted data from earlier steps in a query speeds up the sorting of subsequent steps. Additionally, PostgreSQL can now use the extended statistics system (accessible via CREATESTATISTICS) to create improved plans for queries with OR clauses and IN/ANY lookup lists.
In PostgreSQL, more types of aggregate queries and grouped queries can take advantage of PostgreSQL's efficient hash aggregation feature, because queries with large aggregates do not have to fit entirely in memory. The performance of queries with partitioned tables has been improved because there are now more cases where partitions can be prune and partitions can be directly joined.
Management optimization
Vacuuming is an important part of PostgreSQL management, which enables the database to reclaim storage space after updating and deleting rows. Although previous PostgreSQL versions have done work to alleviate the cleanup overhead, this process can also present administrative challenges.
PostgreSQL continues to improve vacuuming by introducing parallelizedvacuum for indexes system. In addition to the cleanup performance benefits it provides, the use of this new feature can be tuned for specific workloads because administrators can select the number of parallel workers to run. In addition to these performance benefits, data inserts can now trigger autovacuum process.
Replication slots (used to prevent WAL write-ahead logs from being deleted before they are received by the replica) can be adjusted in PostgreSQL to specify the maximum number of WAL files to retain and help avoid out of disk space errors.
PostgreSQL has also added more ways administrators can monitor database activity, including from reference WAL usage statistics EXPLAIN, the progress of streaming base backups, and the progress of the ANALYZE command. Additionally, you can use the new pg_verifybackup command to check the integrity of pg_basebackup output.
Facilitates application development
PostgreSQL makes it easier to work with PostgreSQL data types from different data sources. This release adds datetime() functionality to its SQL/ JSON path support, a feature that converts valid time formats (such as ISO 8601 strings) to PostgreSQL native types. In addition, UUID The v4 generation feature gen_random_uuid() function is now available without installing any extensions.
PostgreSQL’s partitioning system is more flexible because partitioned tables fully support logical replication and before row-level triggers.
The FETCH FIRST syntax in PostgreSQL has been extended to include the WITH TIES clause. When specified, WITH TIES includes " tie" with any row that is the last row in the result set.
Security improvement
PostgreSQL’s extension system is a key component of its robustness because it allows developers to extend its functionality. In previous versions, new extensions could only be installed by the database superuser. To more easily take advantage of PostgreSQL's scalability, PostgreSQL added the concept of "trusted extensions", which allows database users to install extensions marked as "trusted" by the superuser. Some built-in extension flags are trusted by default, including pgcrypto, tablefunc, hstore, and others.
For applications that require a secure authentication method, PostgreSQL allows clients to require channel binding when using SCRAM authentication. binding), and the PostgreSQL foreign data wrapper (postgres_fdw) can now use certificate-based authentication.
PostgreSQL (64-bit) update log
1. Fixed other bugs;
2. Optimized software compatibility.
Huajun editor recommends:
After official continuous improvements, PostgreSQL (64-bit) can meet all your needs. Come download and experience it. Of course, this site has also carefully prepared for youSQL Server automatic installer,Data Loader,SQLyog,access tools,DBeaver
Useful
Useful
Useful