Archive for the tag 'postgresql'

Aug 03 2007

Help! My Hierarchy is Slow – Faster Hierarchies with Nested Sets

Published under Technology

A great many applications, including many that I’ve worked on, have a hierarchy of things: of parts, of people, of organizations, etc. The way most of us represent such hierarchy is with the first thing that generally comes to mind: make each Widget have a parent Widget, with a table like so: create table widget [...]

2 responses so far

Jan 27 2007

DRBD on Ubuntu

Published under Technology

This week I experimented with DRBD (Distributed Replicated Block Device) which is “a block device which is designed to build high availability clusters. This is done by mirroring a whole block device via (a dedicated) network. You could see it as a network raid-1.” DRBD can be used for build a “poor man’s SAN”, a [...]

3 responses so far

« Newer Entries