8 posts tagged with “PostgreSQL”

Tuning `work_mem Setting in PostgreSQL to Speed Up Slow SQL Queries

April 16, 2016

A little trick to speed up queries in PostgreSQL that aggregate, sort or join large datasets.

Maintaining a PostgreSQL database health with ANALYZE, REINDEX, and VACUUM commands

April 01, 2016

How to improve query speed in PostgreSQL and protect from table and indexes bloat by periodically running these three database maintenance commands.

Indexes on Expressions in PostgreSQL

April 01, 2016

A way to speed up SELECT queries and enforce data constraints in PostgreSQL with expressions and deterministic functions.

OVERLAPS Operator in PostgreSQL

March 30, 2016

How to check if two datetime ranges overlap in PostgreSQL.

Partial indexes in PostgreSQL. Part 2: Query performance

March 29, 2016

How to make SELECT, INSERT, DELETE and UPDATE queries in PostgreSQL faster by using partial indexes.

Partial indexes in PostgreSQL. Part 1: Data Integrity

March 27, 2016

How to enforce data integrity constraints on a subset of rows in PostgreSQL.

BETWEEN SYMMETRIC operator in PostgreSQL

March 20, 2016

X BETWEEN SYMMETRIC Y AND Z is PostgreSQL operator that swaps Y and Z automatically if Y > Z to always use a nonempty range.

Tools and Resources for PostgreSQL and Ruby On Rails.

August 10, 2014

Learn what gems are available to make it easier to work with hstore columns and how to use Postgress arrays and indexes more efficiently.

Browse all tags

Copyright © 2014-2020 Andrei Gridnev