Imagine you have this piece of text:

I am stupid\

And what to change it to

Top 10 Most Dangerous Places In The World

I have been trying to port an application of mine to JBoss 6, and managed to get there from JBoss 5.1.0.CR1 without too much hassle. However my MBeans did not show up...

I could find no information as to why this is broken on the wonderful internet. I tried posting on JBoss' forums but as usual, I was ignored on there. Never get any responses. Guess you have to pay for that. I am digressing.

Eventually I figured it out. Here are the details:

About 6 years ago I created a web based application using J2EE, a DAO layer using JDBC to a PostgreSQL database. The J2EE application container ran on its own server, and the PostgreSQL on a dedicated server as well. The two servers were connected with fast gigabit ethernet. The DB is located on a SAN attached to the database server using Fibre Channel.

The main database size has since grown, and is now 110GB. The largest table has about 180 million rows, and there are about 136 tables. When I wrote it originally, multicored CPU's did not exist. Servers with multiple CPU's did, but the system was never deployed on such a configuration.

There is a process that runs once a month that performs a lot of reads on the database, perform some calculations and then writes the data to several tables. This process recently took 491 minutes to complete.