Postgres and Open Source Experts

24x7x365 since 1997

Education

Professional Postgres and Open Source support

Command Prompt, Inc., is the oldest Postgres Company in North America and one of the oldest Open Source firms still operating today. We serve our clients with best in class expertise and professionalism. You can read more about support and services here:


You have landed at the largest single source of Postgres education blogs in the world. At Command Prompt, we believe deeply that the education of the community is critical to the continued success of Postgres and related technologies. We hope you find content you are looking for and don't hesitate to Contact us today for all your Postgres and Open Source consulting and support needs.

The Risks of Not Having a Multi-Region PostgreSQL Cluster

Introduction:

In today's fast-paced digital landscape, data is at the heart of every organization's success. The PostgreSQL database system is a robust and popular choice for managing critical data, but ensuring database availability, scalability, and resilience is crucial. One strategy that can significantly mitigate risks associated with database availability is adopting a multi-region architecture. SaaS applications in particular are often implemented as single-region applications, and can benefit greatly from a multi-region approach.  In this blog post, we'll delve deep into the risks of not having a multi-region strategy for your PostgreSQL database system and explore why it's a game-changer in today's data-centric world.

pglogical Rediscovered: A Fresh Approach to Logical Replication for Ultra-high Availability

by Hari Kiran

August 22, 2023

Data replication is an essential aspect of modern database management systems, ensuring data availability, fault tolerance, and scalability. In the PostgreSQL world, a groundbreaking extension called Spock has emerged, transforming the way multi-active replication is handled. Spock, based on the pglogical logical replication tool, brings in a host of new features, including conflict resolution and avoidance, asynchronous replication, and more. In this blog post, …

What is PostgreSQL?

PostgreSQL is the only Open Source database in the world that focuses on correctness first and extends that correctness to features such as NoSQL (JSON), ASYNC/SYNC Binary and Logical Replication. PostgreSQL also has features such as Horizontal partitioning, Stored Procedures and abilities to use replication to other legacy database systems such as MSSQL and Oracle.

PostgreSQL EOL (Extended Support)

Command Prompt with an appropriate support contract will provide 24x7x365 support for EOL versions of PostgreSQL up to 8 years from the initial release date. This extends the support lifecycle of a PostgreSQL release by 3 years.

What is Postgres (summary)

PostgreSQL, often referred to simply as "Postgres," is a popular open-source relational database management system (RDBMS). It is known for its stability, robustness, and support for a wide range of advanced features, making it a popular choice for large-scale, high-performance applications.

PostgreSQL was first released in 1996 as an Open Source project by the PostgreSQL Global Development Group. It is a fork of work done on Ingres and later Postgres …

Postgres Conference, PostgresConf and PgConf

In the past Postgres Conference has gone by many names including, Postgres Conference, PostgresConf, PgConf.US and PgConf.Org. These are all the same organizations they all refer back to https://postgresconf.org, e.g; Postgres Conference now.

PostgreSQL Indexes: B-Tree

In older versions of PostgreSQL, a B-tree index only contained pointers to the heap (table) of where a particular set of data could be accessed. This can cause performance issues because we first need to scan the index and then retrieve the data from the table. While Index scans are relatively cheap due to how they store data, table scans can be very expensive because the data can be at any place within the table. Though current enterprise methods of storage have alleviated much of this (SSD/NVME) performance impact, it still exists as we need to search for the data twice.

EnterpriseDB (EDB) vs PostgreSQL

Command Prompt understands that sometimes a closed source version of software provides better features than the Open Source counterparts. However, it is Command Prompt’s considerable experience over 25 years of providing expert PostgreSQL professional services and support that there are a minute number of closed source opportunities for PostgreSQL. The ecosystem and community is vibrant and continuing to solve the problems that enterprises face in a collaborative and Open Source way.