OtterTune

How much do you know about Postgres data types? Rustcode Web provides an overview of numeric, character, temporal, boolean, binary, array, JSON (and JSONB) and geometric types.

What are data types in Postgres? PostgreSQL, often referred to as Postgres, is a robust open-source relational database management system (RDBMS) known for its advanced…

Yikes, a query tied to indexing that ran for 1,076 minutes and kept climbing. Alejandro García Montoro dives into the solution to this problem and lessons learned, noting that query optimization is rarely linear.

Making a Postgres query 1,000 times faster Learn how we discovered what was slowing down large database queries, and what we did to make Postgres queries 1000x faster.