Vertraust du deiner Datenbank? ;-)
Aus der PostgreSQL Admin-Mailingliste:
Frage: "So are there any Postgresql tools for analyzing and repairing the "offline" database files (like e.g. the MySQL myisamchk-tool)..."
Antwort: "The philosophy is different. PostgreSQL tries to bring up your database and make it available as quickly as possible, even after a crash. The checking of any changed data blocks is performed automatically during recovery - so no need to run a manual tool while the server is down.
The idea that you'd need a checking tool comes from not trusting your database. The PostgreSQL way is to ensure you don't lose that trust because there are no short-cuts and leaps of faith taken to make the database go faster."
Ich lass das einfach mal so stehen ;-)
Posted at 11:00nachm. Dez. 11, 2006 by cetixx in Computers | Kommentare [0]
Ich liebe Slashdot.org...
Die Kommentare sind oft einfach zu heiß, wie der hier zum Thema PostgreSQL vs. MySQL:
"I've managed to get my PostgreSQL installation tuned to very high
speeds simply by switching the database disk over to /dev/null. It runs
fast as hell, and the data integrity is basically the same as MyISAM."
Technorati Tags: postgres, postgresql, mysql
Posted at 11:05vorm. Dez. 06, 2006 by cetixx in Computers | Kommentare [0]