PostgreSQL
Getting out of SQL_ASCII, part 2
So, if you followed the previous blog entry, now you have a new database containing all the static tables encoded in UTF-8 rather than SQL_ASCII. Because if it was not …
tag
PostgreSQL
210 posts
PostgreSQL
Getting out of SQL_ASCII, part 1
It happens that you have to manage databases designed by your predecessor, and it even happens that the team used to not have a DBA. Those histerical raisins can lead to …
PostgreSQL
Resetting sequences. All of them, please!
So, after restoring a production dump with intermediate filtering, none of our sequences were set to the right value. I could have tried to review the process of …
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 …
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 …