Typo Might Suck 2

Posted by Joshua Schmidlkofer Fri, 01 Dec 2006 20:31:00 GMT

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.