Incremental Commits in PostgreSQL

Posted by & filed under PostgreSQL.

On large and/or busy databases it’s often not feasible to update an entire table at one time. For instance, if one has to perform some background DML task to change all credit card limits on a 300gb table that sees 1000 transactions per second, and increase each card limit by $1000. Simply executing an update… Read more »

The next breed of DBA’s?

Posted by & filed under PostgreSQL.

University of California, Berkeley and Carnegie Mellon University students now have what appears to be a first rate course on database internals. What I like about this course is not only is it very practical experience, but also, that it teaches internals. So much of how a database works has to do with how it’s… Read more »