Software Programming
Some emacs nifties
First, here’s a way to insert at current position the last message printed into the minibuffer… well not exactly, in *Messages* buffer in fact. I was tired …
Getting more out of PostgreSQL
Notes on SQL technique, data modeling, and PostgreSQL internals — from the author of The Art of PostgreSQL. New articles are built on the free Lab so you can run every query yourself.
Projects
prefix 1.0~rc2 in debian testing
At long last, here it is. With binary versions both for postgresal-8.3 and postgresal-8.4! Unfortunately my other packaging efforts are still waiting on the NEW queue, …
Projects
prefix 1.0~rc2-1
I’ve been having problem with building both postgresql-8.3-prefix and postgresql-8.4-prefix debian packages from the same source package, and fixing the packaging …
Projects
prefix extension reaches 1.0 (rc1)
At long last, after millions and millions of queries just here at work and some more in other places, the prefix project is reaching 1.0 milestone. The release candidate …
PostgreSQL
PgCon 2009
I can’t really compare PgCon 2009 with previous years versions, last time I enjoyed the event it was in 2006, in Toronto. But still I found the experience to be a …
Projects
Prepared Statements and pgbouncer
On the performance mailing list, a recent thread drew my attention. It devired to be about using a connection pool software and prepared statements in order to increase …
PostgreSQL
Skytools 3.0 reaches alpha1
It’s time for Skytools news again! First, we did improve documentation of current stable branch with hosting high level presentations and tutorials on the …
Projects
Prefix GiST index now in 8.1
The prefix project is about matching a literal against prefixes in your table, the typical example being a telecom routing table. Thanks to the excellent work around …
PostgreSQL
Importing XML content from file
The problem was raised this week on IRC and this time again I felt it would be a good occasion for a blog entry: how to load an XML file content into a single field? The …
Conferences
Asko Oja talks about Skype architecture
In this russian page you’ll see a nice presentation of Skype databases architectures by Asko Oja himself. It’s the talk at Russian PostgreSQL Community …
PostgreSQL
Skytools ticker daemon and londiste
One of the difficulties in getting to understand and configure londiste reside in the relation between the ticker and the replication. This question was raised once more …
PostgreSQL
Comparing Londiste and Slony
In the page about Skytools I’ve encouraged people to ask some more questions in order for me to be able to try and answer them. That just happened, as usual on the …