Projects
prefix 1.1.0
So I had two bug reports about prefix in less than a week. It means several things, one of them is that my code is getting used in the wild, which is nice. The other side …
tag
PostgreSQL
207 posts
Conferences
PGDay.eu, Paris: it was awesome!
moment. Lots of attendees, lots of quality talks ( slides are online), good food, great party: all the ingredients were there! It also was for me the occasion to first …
Projects
prefix 1.0.0
So there it is, at long last, the final 1.0.0 release of prefix! It’s on its way into the debian repository (targetting sid, in testing in 10 days) and available on …
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
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 …