Archive for the ‘PostgreSQL’ Category
Thursday, February 21st, 2008
Through the Planet PostgreQL site I found a nice paper that compares database internals. It provides an interesting read, even if you are not really into databases.
Architecture of a Database System
Joseph M. Hellerstein, Michael Stonebraker and James Hamilton
Posted in PostgreSQL, databases | No Comments »
Tuesday, February 12th, 2008
The common misconception that a serializable transaction will single thread access to an entire table or even an entire database is pretty hard to eradicate. And the sad thing is that everybody just keeps repeating other supposedly informed sources instead of doing a little experimentation. So I have gathered some ...
Posted in PostgreSQL, databases | 5 Comments »
Sunday, February 10th, 2008
In part 1 I showed how to adapt ColdFusion to work with PostgreSQLs native UUID datatype. In this part, I will show how to adapt PostgreSQL to accept ColdFusions native UUID datatype.
UUIDs: equal, but not the same
As ColdFusion developers are very aware thestring representation of a UUID in ColdFusionis ...
Posted in ColdFusion, PostgreSQL | No Comments »
Wednesday, February 6th, 2008
I set up a little test to measure the performance difference between native PostgreSQL UUIDs () and ColdFusion UUIDs stored as a CHAR(35) field in PostgreSQL. First the schema.
CREATE TABLE uuidanswer (
answerID UUID,
displayOrder INT
);
CREATE TABLE uuidtestAssignment (
testAssignmentID UUID
);
CREATE TABLE uuidquestionScore (
...
Posted in ColdFusion, PostgreSQL | 1 Comment »
Tuesday, February 5th, 2008
Today the PostgreSQL Global Development Group announced the release of PostgreSQL 8.3. The major new features that are most exciting to me are:
TSearch has been integrated into the core so PostgreSQL now has Full Text Searching without the need to install additional modules;
all the performance features;
a UUID datatype for storing ...
Posted in ColdFusion, PostgreSQL | 3 Comments »