PostgreSQL optimizer is very smart at optimizing queries, and many of the queries can be rewritten/transformed for better performance.

With the second gen of Graviton2 instances announced, we decided to take a look at the price/performance from the standpoint of running PostgreSQL.

Auditing is required for many security regulations and it is also useful if you want to know what happened in your database, and when and who was responsible for that. In this blog, we will see what pgAudit is and how to audit your PostgreSQL database using it.

The Ugly Duckling of index types

A pure Lua Postgres driver for use in OpenResty & more

※このブログはヌーラバー Advent Calendar 2020の23日目の記事です。明日はChihiro Itoさんの記事です。 はじめに

July 2023: This post was reviewed for accuracy. The first post of this series, Resources consumed by idle PostgreSQL connections, talked about how PostgreSQL manages connections and how even idle connections consume memory and CPU. In this post, I discuss how idle connections impact PostgreSQL performance. Transaction rate impact When PostgreSQL needs data, it first […]

Make your PostgreSQL migrations safe. Contribute to doctolib/safe-pg-migrations development by creating an account on GitHub.

Most common pitfalls that could happen when migrating a database, and how, at Doctolib, we mitigate them

Keeping your database version up to date provides benefits like improved performance and security, access to new features, fixes to known issues, compliance with regulatory requirements, and more. However, there is also a risk of some queries experiencing performance regression following a database upgrade. This risk is higher with major version upgrades because they can […]

PostgreSQL® backup and restore service. Contribute to Aiven-Open/pghoard development by creating an account on GitHub.

Integrate PostgreSQL's enum data type into ActiveRecord's schema and migrations. - GitHub - bibendi/activerecord-postgres_enum: Integrate PostgreSQL's enum data type into Ac...

A Ruby job queue that uses PostgreSQL's advisory locks for speed and reliability.

ActiveRecord PostgreSQL Partitioning. Contribute to rkrage/pg_party development by creating an account on GitHub.

At the very heart of Actual is a custom syncing engine. I'd like to talk about a PostgreSQL feature that enabled a 9-10x performance improvement.

Benchmark v4 uuid generation in postgres

You have a file, possibly a huge CSV, and you want to import its content into your database. There are lots of options to do this but how would you decide which one to use. More often than not the question is how much time would the bulk load would take. I found my self doing the same… Read more

“The greatest force in legacy databases is inertia,” a widely regarded industry analyst once told me. Not superior functionality. Not better performance. Not lower cost. None of the above. Just inertia. Developers might say they prefer to run PostgreSQL to proprietary alternatives (and they do), but enterprises have spent years building data models in Microsoft […]

An in memory postgres DB instance for your unit tests

The least you need to know about Postgres

It's surprisingly hard and we use less than immediately obvious

Go beyond testing and fully automate the release of Postgres extensions on both GitHub and PGXN using GitHub actions.

A Foreign Data Wrapper Library for PostgreSQL

Data Access Library. Contribute to Segfault-Inc/Multicorn development by creating an account on GitHub.

It's surprisingly hard and we use less than immediately obvious