Typo Might Suck

Posted by Joshua Schmidlkofer 01/12/2006 at 12h31

I don't use Ruby much. I use PostgreSQL quite a bit. My blog pisses me off - lots of slow load times, lots of serious lag. Today, I did a "control-R" refresh in Firefox. Eleven (11) Seconds to load the page! It was awful.

Here is what I did....

  • VACUUM
  • REINDEX 
embassy site-packages # vacuumdb -U superpg  -d jmstypo
VACUUM
embassy site-packages # psql -U superpg -d jmstypo \



              -c "reindex database jmstypo;"




NOTICE:  table ......... was reindexed
....
REINDEX

Full load time: 3 Seconds

Referesh time: 1.5 seconds.

I am moving this blog in the next month or two. I want to put ruby onto a faster box. A 1ghz p3 just doesn't buy what it used to.