Up to Something

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.

My Typo is aging a bit, and I have some strange problems. I have seen all my problems as closed tickets in the Typo Trac site. Everytime I try to update though, I get horrible rake errors, etc.

My good friend Nihilist gave me a hot tip that r761 was fairly stable. This seems to have been a good thing.

I also decided to update lighttpd. Gentoo Portage doesn't have 1.4.11, so I had to bump the ebuild, add it to Asylumware Portage and add it myself. No problem. I also put in a couple extras

xXxX@embassy ~/public_html/typo.r761 $ svn export -r761 svn://typosphere.org/typo/trunk
xXxX@embassy ~/public_html/typo.r761 $ rake migrate
....[excess trimmed]......
Extending content table
Converting pages
Updating all articles
Adding podcast metadata fields
Adding Redirect Table
NOTICE:  CREATE TABLE will create implicit sequence "redirects_id_seq" for serial column "redirects.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "redirects_pkey" for table "redirects"
Setting published flag on each comment
xXxX@embassy ~/public_html/typo.r761 $