corner image corner image
corner image corner image
corner image corner image
corner image corner image
corner image corner image
corner image corner image
corner image corner image

Posts Tagged ‘postgresql’

Using atop to track your optimization results

Tuesday, January 29th, 2008

Recently, I rediscovered atop. It is an excellent command-line tool (just like top) that shows some advanced statistics including disk usage and swap page faults per process. For the disk usage to work per process a kernel patch is currently required. However, even without the kernel patch if you know which processes running on your server you’ll be able to guess which is utilizing the disk more.

(more…)

Postgresql is really beating my expectations

Tuesday, January 15th, 2008

Since I updated the website this weekend and it’s been downloading images from MRIS non-stop. In a previous post I said that I had around 900,000 images. I later on discovered that I had dangling images whose listings were deleted. Since this weekend, the update script downloaded almost 820,000 images from MRIS and inserted those binaries inside bytea fields in postgresql. I was expecting things to slow down, however I don’t feel any slow down since the process started. It seems the postgres team really optimized the b-tree indexes to the extreme.

(more…)

corner image corner image
4,280 spam comments
blocked by
Akismet