Tag Archives: postgresql

Two indexing tricks with PostgreSQL

I would like to share two indexing tricks I stumbled upon earlier this year. They are useful when changing the schema for large tables. Context Our database schema seemed rather inefficient: We were using 8-byte bigint types for small integer … Continue reading

Posted in Programming | Tagged , | Leave a comment

Schema diagrams for PostgreSQL

I have made some progress towards the longstanding goal of drawing nice diagrams of database schemas. Firstly, I’ve figured out how to use yEd‘s Entity Relationship node types as table nodes. These special node types have both a node label, … Continue reading

Posted in Programming | Tagged , , , , | 5 Comments

A small contribution to PostgreSQL beta testing

PostgreSQL 9.2 has been in beta for a few weeks, and (since they asked for volunteers) I thought I’d do a bit of informal testing. I’m also eager to see the effects of Index-only scans and other performance improvements (which … Continue reading

Posted in Programming | Tagged | 1 Comment

XML in the database

At work we often need to analyse large sets of XML files. We have a standard XML format that is used for a lot of the data interchange. Each message describes the state of a complex data object at a … Continue reading

Posted in Programming | Tagged , | 1 Comment

Vector re-normalisation with views in PostgreSQL

The much delayed followup to last year’s post Vector denormalisation in PostgreSQL. I’ve been wrestling with rewrite rules and triggers, and discovering it’s not as straightforward as I first thought.

Posted in Programming | Tagged | Leave a comment

Denormalisation aggregate function for Postgresql

A handy function that can be used to build vectors from tables.

Posted in Programming | Tagged | 1 Comment

E-mail recovery

What I did this weekend.

Posted in Programming | Tagged , , , , | Leave a comment