-
Recent Posts
Archives
- June 2016 (1)
- December 2014 (1)
- June 2014 (1)
- March 2013 (1)
- February 2013 (1)
- November 2012 (1)
- October 2012 (1)
- September 2012 (2)
- August 2012 (3)
- July 2012 (7)
- June 2012 (2)
- May 2012 (5)
- April 2012 (4)
- March 2012 (2)
- February 2012 (5)
- January 2012 (5)
- December 2011 (5)
- November 2011 (2)
- October 2011 (6)
- September 2011 (9)
- August 2011 (3)
- July 2011 (2)
- June 2011 (2)
- May 2011 (11)
- April 2011 (9)
- March 2011 (7)
- February 2011 (4)
- January 2011 (1)
Categories (non-disjoint!)
- Games (11)
- Hardware (13)
- Programming (92)
- Higher-level C (5)
- Project 6014 (5)
- Simulation (6)
- Rants (13)
- Reflections (9)
- Reviews (1)
- Science (21)
- Math (8)
- Uncategorized (1)
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
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
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
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
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.
Denormalisation aggregate function for Postgresql
A handy function that can be used to build vectors from tables.
E-mail recovery
What I did this weekend.
Vector denormalisation in PostgreSQL
PostgreSQL is a relational database system, and is designed for the general case. That means it aims for scalability rather than efficiency at any specific data size.