And On This Farm He Had A Blog

@jws In our case, it was because the older versions of Postgres would quickly lose the ability to use indices on oft-changed tables. This, of course, meant the query engine would be reduced to sequential searches. The only way you could fix it was by running VACUUM ANALYZE which could take forever and a day on large databases. Then, it would run great until it "got dirty" from insertions and deletions and you had to do it again.

Contrasting that with "Works with no performance degradation for years on end" made the decision to use MySQL a lot easier. Wasn't all sunshine and roses though because, at the time, MySQL was nowhere near Postgres in terms of features.

NOTE: This was sixteen years ago. I understand it is leagues better now but that experience really soured me on Postgres.

// @streakmachine @kdfrawg

Cracks knuckles at 01:28 and prepares to go back into the salt mines

@kdfrawg In our case, we have quite a few coded extensions to it. Things that go beyond what a stored procedure could do quickly and efficiently.

// @streakmachine

Not dead. Just buried.

I'm too nice. Have a customer who really needs to run a legacy server application, QT3-based, under RHEL7 64 bit.

Presently going through a source RPM of qt3 final and modifying their patches. They did a really good job in most places but there are a few erroneous things that need fixed for it to run properly. Also, we have custom patches that need applied. Some of them actually made it into the official QT3 build (Yay us) but not all of them.

If anyone reading this has ever had to dig deep in QT's source and make corrections at the lower system levels..you can guess my mood right now.

QT 3.3, BTW, was released in 2004.

Next, I need to package the customized version of ANTLR-2.7 we use for that application plus, somehow, make Faircom c-tree source code from 1994 both 64 bit safe and not give GCC an aneurysm.

While I am in here, I will eliminate the dependence on older MySQL and make the database extensions run with MariaDB.

"You know I am up at 5:00AM. Why did you not call and tell me most of the servers were down?"

"We didn't want to bug you."

"Which do you think is more bothersome? Getting a call after it happens and talking you through getting things back up or coming in after things have been down for 2+ hours and everything is in chaos?"

"…oh…"

Welcome to my Monday so far.

@hybotics That gave me flashbacks. I have to download and try that.

// @streakmachine

@streakmachine The original Elite was hands-down my favorite space game. I'm attempting to warm to the new one. Not going to be able to get the full experience until Sunday evening when my flight stick and throttle arrive :)

@matigo It's just poor/shoddy documentation. They have more flight simulator geeks there than game designers, I think.

Current Status: Up too late engaging in a bit of a learning curve.

In Elite, had a delivery to a 'Ogden Depot' in a certain system. No such station found. Finally figured out I had to scan each friggin planet to find where it was (On the surface) and land there. Game gave no such clue nor told me which planet this was on. Had to scan the entire star system to find it.

Playing this game with a mouse and keyboard is a total pain in the hind end as well.

Stupidly trying to play Elite Horizons with a mouse and keyboard.

HOTAS will not be here until tomorrow evening. May as well wait for it before I try again.