Covering indexes in PostgreSQL are an incredibly helpful feature that can help improve the performance of your application when used correctly. This article demonstrates how an application that collects time-series and geospatial data is able to use covering indexes to boost performance.
COPY is also incredibly helpful for ingesting data such as JSON or CSV into a PostgreSQL table, especially if there is a lot of it. Learn how to use COPY to optimize your data loading performance in PostgreSQL.
This article provides an easy recipe for creating a PostgreSQL primary-replica cluster using Docker Swarm.
Easy setup and installation for PostgreSQL 10 and pgAdmin 4 with Docker and open source containers packaged by Crunchy Data.
An overview of how to set up and run PostgreSQL in docker containers using docker 1.12.