09:25 PM ~ 0 Comments

Round and round goes the buffer …

The concept of circular buffer (or ring buffer) is well known. It is immensely useful when dealing with buffering and processing stream of data. All in all, it’s pretty simple to implement, you just have an array of bytes that you treat like a ring by maintaining a begin pointer and an end pointer. When [...]

Continue Reading

05:27 PM ~ 2 Comments

Some quick numbers about SSD for PostgreSQL

SSDs are not new anymore, there are plenty of benchmark and tests out there. Even on the specific combination of SSDs and PostgreSQL, there is quite a lot of availabe data. This post by Jignesh Shah is a good example (fyi, if you use PostgreSQL on Solaris, that blog’s awesome !).
And when the time came [...]

Continue Reading