Finding and killing long running queries on PostgreSQL

From time to time we need to investigate if there is any query running indefinitely on our PostgreSQL database.

These long running queries may interfere on the overall database performance and probably they are…

Unique partial indexes with PostgreSQL

How to use unique partial indexes to avoid conditional duplication

When you need to deal with concurrency and unique records databases are your friend. Unique indexes are the best way to avoid data inconsistence and duplication.

The Postgres RETURNING clause

How to return data related to updated rows.

The problem

Here is my situation. I have a products table and each product needs to be approved by someone.

The initial solution

Time range operations with Rails

Returning basic time ranges using ActiveSupport methods.

How many times you needed to return a specific time range in order to use it on a query?

Less is good.

Learning how to embrace constraints.

Better to be safe, than to be sorry

Two strategies to safe deploy in the wild