As far as PostgreSQL is concerned, GIN means an access method (index type) rather than a drink. The acronym stands for Generalized Inverted Index. This article tries to explain how data is organized in the GIN index and how search works.

Layout

The current implementation of GIN index has much to do with B-tree, so let's look at B-tree first. (more…)

Virtualization has been one of the pre-dominant topics in the past couple of years. Not going to the cloud is considered to be uncool - at minimum it feels like being stake in the stone age of computing.

What does going to the cloud actually mean? First of all it means "virtualization". This is cool from many points of view but what does it mean for performance? Virtualization usually does not good, this was clear from the start. (more…)