Daniel Westermann

getting started with postgres plus advanced server (1) – setting up ppas

I did several posts around postgresql and postgres plus advanced server in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and(…)

bulk loading semi structured data in postgresql

The last post took a look at how to efficiently load 1m rows into a table in PostgreSQL. In this post I’ll take a look on how to do the same with semi structured data.

Variations on 1M rows insert(2): commit write – PostgreSQL

Franck was quite fast with his second post Variations on 1M rows insert(2): commit write. Lets see what we can do on the PostgreSQL side. I’ll take the same test table as Franck again: create(…)

Variations on 1M rows insert (1): bulk insert – PostgreSQL

When I read Franck’s post about Variations on 1M rows insert (1): bulk insert I thought doing quite the same in PostgreSQL might be interesting. Lets start by using the same test tables, one using a primary(…)