PostgreSQL

Ensuring databases' high availability (HA) is crucial for business continuity and performance. PostgreSQL, one of the most popular open-source relational databases, offers robust HA solutions, and Tessell PostgreSQL is a standout example.

PostgreSQL 16 introduces a new libpq connection option, load_balance_hosts. This feature is particularly useful when an application needs to connect to multiple target nodes randomly to execute SQL queries. For instance, consider running a series of SQL queries on a group of read replicas synchronized with the primary node. This approach will yield better results, as it prevents all application queries from hitting the same replica or a limited set of servers. We can also balance the report-related SQL queries by using one primary and one replica node, instead of always relying on the reporting server to produce the data.

PostgreSQL 16 has many new and valuable enhancements and we thought it would be great to deep dive into these for our users. While we may not be able to look at all of them in one go, we thought to filter and curate the best ones as part of this article.

Explore the developments in PostgreSQL in 2023, from the emergence of a premier vector database with extensions like pgvector to first-class support for time series data. Discover the major release of PostgreSQL 16, featuring advanced query optimization and enhanced JSON handling.

PostgreSQL, often referred to as Postgres, stands as a powerful open-source relational database management system (RDBMS) renowned for its robustness, extensibility, and adherence to SQL standards.

PostgreSQL, a powerful open-source relational database management system, has long been revered for its robustness, extensibility, and SQL compliance. However, in recent times, there has been a paradigm shift in the way databases are utilized, with an increasing focus on vector data processing. This has led to the emergence of PostgreSQL as a formidable player in the realm of vector databases, further strengthened by the innovative pgvector extension.

Tessell for PostgreSQL comes with several extensions out of the box that enhance the capabilities of a PostgreSQL instance.

As organizations increasingly rely on PostgreSQL for their data storage needs, a powerful tool has emerged to take PostgreSQL management to the next level: Tessell

Tessell HPC PostgreSQL produces 70% higher IOPS as compared to Aurora PostgreSQL for the identical SLOB workload at a much lower cost. With Tessell, there is no IOPS metering so you always get price predictability alongside massive performance uplift. Your demanding workloads can significantly benefit from the Tessell database service.

PostgreSQL 15 has many new and valuable enhancements and we thought it would be great to deep dive into these for our users. While we may not be able to look at all of them in one go, we thought to filter and curate the best ones as part of this article.