.org TLD Now Runs on PostgreSQL
johnnyb writes "The .org domain, which has long run on Oracle systems, is now being transferred to a PostgreSQL system. I guess we can now dispel the "untested in mission-critical applications" myth."
← Back to Stories (view on slashdot.org)
I had the misfortune of dealing with oracle tech support team once and I can say I am not surprised the ".org" domain has shifted to PG.
The DB was locking up when trying to retrieve data from a large table (>10 M rows) using a very complex query.The oracle guys kept suggesting that reduce the size of the table.
Now seriously is that a valid option ? Hey man , I have a million bucks in my acct. and i can't withdraw from the ATM ??
Just delete some of it and then try again ?
Or the most common answer from Oracle tech team is "we know its a problem but we will not fix it in this release. Just buy the next version if you want it fixed ?
for the last time people, I am "frodo from middle eaRTH", not "middle eaST".
I was a designer of the system that runs .nz (New Zealand), which is also based around PostgreSQL, running on three replicated back-end application servers.
The system was developed in mod Perl and went live on October 14th 2002.
The plan is to release this (including client software) under the GPL after a stabilisation period.
I love PostgreSQL, have used it in a small (million-record) transactional application with great success, and am pleased to see the implied advocacy of having .org run on it. Nonetheless 2.4 million
records is hardly enterprise-level stress. I would really like to see
some serious benchmarks against Oracle. My tests on a small PC-based Linux
server last year showed that pg beat Oracle mainly because the bloat of
Oracle caused excessive thrashing, but on a large mainframe-type
application - billion-record type stuff - I simply have no idea. A
couple of years ago some benchmarks were published on the web but got
quickly taken down by Oracle under threat of lawsuit - their license
doesn't allow publication of benchmarks - and I never got to see them.
I think this is wrong. Perhaps the recent ruling against EDA benchmark
restrictions will open a door towards Oracle benchmarks?