Blog

Archive:

Search site:

Tags:

Compilation (1) Concurrency (3) docker (2) Execution Plans (6) Indexes (2) internals (11) linux (4) Name Resolution (1) Optimization (6) Parameterization (1) Performance (9) Performance Tuning (2) pgadmin (1) postgres (6) RCSI (2) Security (1) SQL Server (22) Statistics (2) Transactions (1) Version Store (2)

Categories:

Docker (2) Linux (4) PostgreSQL (6) SQL Server (22)

Tag: postgres

  • Setting up the Stack Overflow database in Postgres

    Setting up the Stack Overflow database in Postgres

    I’ve worked with Microsoft SQL Server for many years as well as dipping my toes into the MySQL world as and when required, however, I have not done as much with PostgreSQL. It’s hard to ignore the momentum that Postgres has built in recent years; it is moving up the Stack Overflow Developer Survey and…

    Keep reading

  • Four Flavours of Postgres Install – Part 4 (Windows)

    Four Flavours of Postgres Install – Part 4 (Windows)

    This post is the next in a short series exploring the different ways we can install a PostgreSQL server. This time, we’ll look at a vanilla install on Windows – no Docker involved. The VM I’ll use the same spec VM as in the last post, which is sufficient for demonstration purposes: Firstly, let’s hop…

    Keep reading

  • Four Flavours of Postgres Install – Part 3 (Docker Container, Windows Host)

    Four Flavours of Postgres Install – Part 3 (Docker Container, Windows Host)

    In this series, we’ve been working through the different ways to install PostgreSQL. In Part 3, we move into the Windows world and will install PostgreSQL as a Docker container. Unlike Part 2, where the host was a Linux machine, this time, the host is a Windows server. The VM I’ll use the same spec…

    Keep reading

  • Four Flavours of Postgres Install – Part 2 (Docker Container, Linux Host)

    Four Flavours of Postgres Install – Part 2 (Docker Container, Linux Host)

    In the last post, the first in this series about installing PostgreSQL, we looked at how to install PostgreSQL on Linux. This post is an alternative install method where we’ll look at how to install PostgreSQL on a Docker container, where the container is run on a Linux host. As before, we’ll run through the…

    Keep reading

  • Four Flavours of Postgres Install – Part 1 (Linux)

    Four Flavours of Postgres Install – Part 1 (Linux)

    This is the first post in a short series documenting the various methods of installing PostgreSQL. In this post, we’ll look at how to install PostgreSQL natively on Linux and connect to the cluster we install from a remote client. The VM Firstly, let’s create a VM to install PostgreSQL on. I won’t detail the…

    Keep reading

  • Installing PGAdmin on Linux Mint

    Installing PGAdmin on Linux Mint

    This is a quick walkthrough of how I installed pgAdmin on Linux Mint. pgAdmin is one of the main management and query tools for PostgreSQL, which I like to use in conjunction with DBeaver. Installation The pgAdmin tool isn’t in the standard Linux Mint repositories, only phpPgAdmin, which is a web-based tool, similar to the…

    Keep reading