postgresql

I have now seen this problem twice. The current one in version 8 and the last time in version 7.3 of postgresql.

A table goes bad in a way I haven't discovered with the nasty side effect of taking a long time to access.

I have a table called announcements for the home page of crazedimaginations.net. Some announcements are from the cast director and are handled differently. So I make two calls to that table when I paint the home page.

Right now, there are six announcements in that table. Just six. But any query on that table takes slightly more than 7 seconds. Thus, the home page takes 15 seconds to load.

The only way I have found to fix the problem is to create a temp table as a query from the old table, delete the old table, then create the table again from the temp. It solves the problem.

But it also means I have to drop all the dependent objects and recreate them. It is a pain in the butt.

I have not found a way to repair the bad table. None of the tools I know about work.

Sigh.

Anyway, the home page does not take forever to load anymore.

procrastination

Everyone who procrastinates has their reasons. Here's mine. I grind to a complete stop when I decide I'm not going to succeed. Sometimes I don't get going again and sometimes I soldier on with the weight of the world on my back.

And it is always a complete waste of time and energy. It is a cesspool of a worry pit that I fall into while pretending to it's just the very place I long to be.

The smaller issue I fixed this morning with the crazedimaginations.net home page. I don't know what I expected there, but I was dragging my feet in trouble-shooting that problem.

The large issue is more important. I've been dragging my feet, to the point of not moving at all, on learning how to set up High Availability Linux server clusters. Last night, I spent two hours looking at three web sites and reading everything on them.

Setting up a two-node fail-over server cluster at the level I need is simple. I've been a complete boob about it.

I need to build four computers this week. Two different two-node server clusters. One for Estreet to finally get my server farm up to snuff and the other for Moffitt & Associates.

I'm really looking forward to playing around with this. I'm going to use heartbeat and drbd.

This is exciting.