Redrock Postgres Documentation
Home Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

Why Redrock Postgres?

PostgreSQL is an advanced relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. In short, PostgreSQL has already gained a good reputation for data consistency, stability, high performance, feature rich and developer friendly.

Although PostgreSQL has performed well in most senarios, there are still some areas for improvement, and that’s exactly what Redrock Postgres has done to achieve:

Feature Customer benefits
Implement in-place updates by introducing undo logs and marking index records deleted, and reuse space immediately after a transaction commit that performs a delete or non-in-place update Make the applications perform UPDATE/DELETE operations more stably and improve the storage space utilization
Perform updates to related index columns without updating each index, reducing write amplification Improve storage IO utilization and extend the availability of storage devices
Marks index records with transaction status information SELECT operations based on index scans will perform more stably
The transaction ID is identified by using the undo transaction table record entry to solve the transaction ID wraparound issue The system does not need to trigger high-risk freeze operations periodically, leaving the system in a stable and predictable operating state all year round
Removed the dedicated autovacuum process to perform retail deletes Make your database system run more stable
Subtransactions implemented based on the undo record position You can confidently use the basic features of savepoints, and exception handling code blocks in stored procedures
Supports statement level atomicity, a transaction behavior compatible to those popular relational databases Reduce the risk of migrating to Postgres from other databases
Run on Windows using a multithreaded Postgres model You can easily deploy and run Postgres efficiently on Windows
Revolutionary network attached tablespace technology You can flexibly respond to the growth of business data volume through network attached tablespaces
Multi-tenant database Use the database’s multi-tenant capabilities to support your SaaS applications
Sophisticated event trigger mechanism Flexibly auditing, publishing and subscribing the DDL operations