PostgreSQL

Posts in 2024
  • Will PostgreSQL Change Its License?

    March 20, 2024 in PostgreSQL

    Will PostgreSQL Change Its License?

    PostgreSQL will not change its license. This article is a response from PostgreSQL core team members on this question.

    Read more

    PostgreSQL will not change its license. This article is a response from PostgreSQL core team members on this question.

    Read more

  • Postgres is eating the database world

    March 04, 2024 in PostgreSQL

    Postgres is eating the database world

    PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to engulf the entire database realm. The trend of “Using Postgres for Everything” is no longer limited to a few elite teams but is becoming a …

    Read more

    PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to engulf the entire database realm. The trend of “Using Postgres for Everything” is no longer limited to a few elite teams but is becoming a …

    Read more

  • Technical Minimalism: Just Use PostgreSQL for Everything

    February 19, 2024 in PostgreSQL

    Technical Minimalism: Just Use PostgreSQL for Everything

    Whether **production databases** should be containerized remains a controversial topic. From a DBA's perspective, I believe that **currently**, putting production databases in Docker is still a bad idea.

    Read more

    Whether **production databases** should be containerized remains a controversial topic. From a DBA's perspective, I believe that **currently**, putting production databases in Docker is still a bad idea.

    Read more

  • New PostgreSQL Ecosystem Player: ParadeDB

    February 18, 2024 in PostgreSQL

    New PostgreSQL Ecosystem Player: ParadeDB

    ParadeDB aims to be an Elasticsearch alternative: "Modern Elasticsearch Alternative built on Postgres" — PostgreSQL for search and analytics.

    Read more

    ParadeDB aims to be an Elasticsearch alternative: "Modern Elasticsearch Alternative built on Postgres" — PostgreSQL for search and analytics.

    Read more

  • PostgreSQL's Impressive Scalability

    January 13, 2024 in PostgreSQL

    PostgreSQL's Impressive Scalability

    This article describes how Cloudflare scaled to support 55 million requests per second using 15 PostgreSQL clusters, and PostgreSQL's scalability performance.

    Read more

    This article describes how Cloudflare scaled to support 55 million requests per second using 15 PostgreSQL clusters, and PostgreSQL's scalability performance.

    Read more

  • PostgreSQL Wins 2024 Database of the Year Award! (Fifth Time)

    January 05, 2024 in PostgreSQL

    PostgreSQL Wins 2024 Database of the Year Award! (Fifth Time)

    DB-Engines officially announced today that PostgreSQL has once again been crowned "Database of the Year." This is the fifth time PG has received this honor in the past seven years. If not for Snowflake stealing the spotlight for two years, the database world would have almost become a PostgreSQL solo show.

    Read more

    DB-Engines officially announced today that PostgreSQL has once again been crowned "Database of the Year." This is the fifth time PG has received this honor in the past seven years. If not for Snowflake stealing the spotlight for two years, the database world would have almost become a PostgreSQL solo show.

    Read more

  • PostgreSQL Outlook for 2024

    January 05, 2024 in PostgreSQL

    PostgreSQL Outlook for 2024

    PostgreSQL core team member Jonathan Katzs outlook for PostgreSQL in 2024, reviewing the progress made over the past few years.

    Read more

    PostgreSQL core team member Jonathan Katzs outlook for PostgreSQL in 2024, reviewing the progress made over the past few years.

    Read more

Posts in 2023
  • PostgreSQL Macro Query Optimization with pg_stat_statements

    October 26, 2023 in PostgreSQL

    PostgreSQL Macro Query Optimization with pg_stat_statements

    **Query optimization** is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by `pg_stat_statements` for macro-level PostgreSQL query optimization.

    Read more

    **Query optimization** is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by `pg_stat_statements` for macro-level PostgreSQL query optimization.

    Read more

  • FerretDB: PostgreSQL Disguised as MongoDB

    October 08, 2023 in PostgreSQL

    FerretDB: PostgreSQL Disguised as MongoDB

    FerretDB aims to provide a truly open-source MongoDB alternative based on PostgreSQL.

    Read more

    FerretDB aims to provide a truly open-source MongoDB alternative based on PostgreSQL.

    Read more

  • How to Use pg_filedump for Data Recovery?

    September 27, 2023 in PostgreSQL

    How to Use pg_filedump for Data Recovery?

    Backups are a DBA's lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe `pg_filedump` can help you!

    Read more

    Backups are a DBA's lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe `pg_filedump` can help you!

    Read more