Projects
pgloader tutorial
To finish up the pgloader series, I’ve compiled all the information into a single page, the long awaited pgloader tutorial. That should help lots of users to get …
tag
PostgreSQL
208 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
Skytools3 talk Slides
In case you’re wondering, here are the slides from the CHAR(11) talk I gave, about Skytools 3.0, soon to be released. That means as soon as I have enough time …
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 …
debian
Multi-Version support for Extensions
We still have this problem to solve with extensions and their packaging. How to best organize things so that your extension is compatible with before 9.1 and 9.1 and …
Conferences
Back from Ottawa, preparing for Cambridge
While Magnus is all about PG Conf EU already, you have to realize we’re just landed back from PG Con in Ottawa. My next stop in the annual conferences is CHAR 11, …