Blog
Compiling and installing OpenSRF 2.2 on Centos 5.9
Calling Bullsh*t in Open Source communities
postgres_fdw for 9.2
The steaming pile that is Precise with kernel 3.2
before upgrade to 3.9
08:35:01 AM CPU %user %nice %system %iowait %steal …
Returning multiple results without a round trip
"Would it be necessary to modify the wire protocol to support multiple query/result-set combinations per server round-trip? That is, to be able to send a hundred different queries (each with a different number and type of columns in the result set) and receive a hundred different results all in a single network round-trip? That is …
Modifying the backend protocol for 9.4/10.0.
The wire protocol is the language spoken between a client and the server of postgresql. The majority of programming languages out there do not implement their own version of the protocol instead opting to bind to the C library libpq. There …
Considering PITRtools 1.4
Remembering to check the docs: Autovacuum
So what is the problem? The problem is they weren't running Autovacuum. Now many …
GNU and the FSF should be split up
Yes, I really did just write that. I believe the the FSF no longer fulfills its mission. Wait, let's back up a step. I can feel the torches started to be covered in pitch and the frankenstein cry of, "kill the heretic" starting to rumble through the old streets of the Free Software country. I am not here to say that the FSF is …
Writing a custom conflict handler for Bucardo 4
Bucardo, an asynchronous multi-master replication system (or, maybe the asynchronous multi-master replication system for PostgreSQL, cause I know of no other actively developed ones), deals with replication conflicts by providing conflict handlers in a form of standard (built-in) or custom code procedures. The built-in conflict handlers resolve a conflict by taking a row from the source or the target databases (in Bucardo 4 only 2 masters are supported, called 'source' …