tag

PostgreSQL

207 posts

Projects

pgloader constant cols

The previous articles in the pgloader series detailed How To Use PgLoader then How to Setup pgloader, then what to expect from a parallel pgloader setup, and then …

Projects

pgloader reformating

Back to our series about pgloader. The previous articles detailed How To Use PgLoader then How to Setup pgloader, then what to expect from a parallel pgloader setup. This …

PostgreSQL

See Tsung in action

Tsung is an open-source multi-protocol distributed load testing tool and a mature project. It’s been available for about 10 years and is built with the Erlang …

Projects

Parallel pgloader

This article continues the series that began with How To Use PgLoader then detailed How to Setup pgloader. We have some more fine points to talk about here, today’s …

Projects

How to Setup pgloader

In a previous article we detailed how to use pgloader, let’s now see how to write the pgloader.conf that instructs pgloader about what to do.

PostgreSQL

Next month partitions

When you do partition your tables monthly, then comes the question of when to create next partitions. I tend to create them just the week before next month and I have …

Projects

How To Use PgLoader

This question about pgloader usage coms in quite frequently, and I think the examples README goes a long way in answering it. It’s not exactly a tutorial but is …

Conferences

Back From CHAR(11)

CHAR(11) finished somewhen in the night leading to today, if you consider the social events to be part of it, which I definitely do. This conference has been a very good …

PostgreSQL

Preparing for PGCON

It’s this time of the year again, the main international PostgreSQL Conference is next week in Ottawa, Canada. If previous years are any indication, this will be …