This module provides an optimized partitioning mechanism and functions to manage partitions.

'Pivoting' in data is a common activity, especially if you’ve ever analyzed data in Excel. It’s also possible to do in Postgres, as demonstrated here.

SQL isn’t always the prettiest language to work with but if you use the right tools, such as Postgres’ CTEs, it can be made easier and you can gradually build up to something clean but powerful. Disclaimer: Page autoplays MIDI music and is very 1996.

Vitesse DB Enterprise Edition is PostgreSQL enhanced with builtin multi-threading, LLVM JIT and compressed column store. Check out the TPC-H 100 numbers, and discover why PostgreSQL is ready for reporting and data warehouse.

A comparison of the performance and execution paths of inner joins and ‘where exists’ in PostgreSQL 9.5.

In many scenarios you’ll want to pull production data to staging, but the time that takes can be time you’re not testing... This post digs into some ways you can speed up getting a copy of production data elsewhere.

Sometimes your database contains things that don’t parse easily with LIKE %, hence you might use a regex. Luckily, Postgres can play really well with regular expressions as seen here.

We're in demand ....and that means you could be too!. Due to our continued growth we're looking for people with relevant PostgreSQL skills and experience. Check out our vacancies.

Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today!