PostgreSQL
Database Virtual Machines
Today I’m being told once again about SQLite as an embedded database software. That one ain’t a database server but a software library that you can use …
Posts
PostgreSQL
Partitioning: relation size per “group”
This time, we are trying to figure out where is the bulk of the data on disk. The trick is that we’re using DDL partitioning, but we want a “nice” view of size per …
Projects
dim-switch-window.el: fixes
Thanks to amazing readers of planet emacsen, two annoyances of switch-window.el have already been fixed! The first is that handling of C-g isn’t exactly an option …
Projects
dim-switch-window.el
So it’s Sunday and I’m thinking I’ll get into el-get sometime later. Now is the time to present dim-switch-window.el which implements a visual C-x o. I …
Software Programming
ClusterSSH gets dsh support
If you don’t know about ClusterSSH, it’s a project that builds on M-x term and ssh to offer a nice and simple way to open remote terminals. It’s …
debian
Emacs and PostgreSQL
Those are my two all times favorite Open Source Software. Or Free Software in the GNU sense of the world, as both the BSD and the GPL are labeled free there. Even if I …
PostgreSQL
Background writers
There’s currently a thread on hackers about bg worker: overview and a series of 6 patches. Thanks a lot Markus! This is all about generalizing a concept already in …
PostgreSQL
Logs analysis
Nowadays to analyze logs and provide insights, the more common tool to use is pgfouine, which does an excellent job. But there has been some improvements in logs …
PostgreSQL
Using indexes as column store?
There’s a big trend nowadays about using column storage as opposed to what PostgreSQL is doing, which would be row storage. The difference is that if you have the …
Conferences
MVCC in the Cloud
At CHAR(10) Markus had a talk about Using MVCC for Clustered Database Systems and explained how Postgres-R does it. The scope of his project is to maintain a set of …
Conferences
Back from CHAR(10)
It surely does not feel like a full month and some more went by since we were enjoying PGCon 2010, but in fact it was already the time for CHAR(10). The venue was most …
PostgreSQL
Back from PgCon2010
This year’s edition has been the best pgcon ever for me. Granted, it’s only my third time, but still :) As Josh said the “Hall Track” in …