Is vacuumin postgres still basically means that you need downtime?
Oracle vs. PostgreSQL – A Comment
11–20 of 238 posts
Re: Oracle vs. PostgreSQL – A Comment
#12It has been known for DECADES that Oracle is outrageously expensive compared to the competition. But the unwillingness of larger companies to go with open-source databases which have no multi-billion dollar company behind them has kept Oracle in the saddle all these years.
I think that mission critical, legacy systems from a time before there was big OSS acceptance at the CTO level is the main reason. I’m not sure how many greenfield projects are using Oracle, but I’d expect that is rapidly decreasing over time. However, if you’ve had an Oracle db running for 20 years, and the cost of screwing up a migration starts at 9 figures, and runs into the 10 figures, then Oracle have you by the cost-benefit balls.
Re: Oracle vs. PostgreSQL – A Comment
#13Anyone here use Patroni for automated high availability with postgres? Does it “just work” or do you need a lot of housekeeping?
Perhaps our setup was different than the sibling comment describing a bad experience, but I found, compared to other complex K8S charts, that patroni was exceptionally reliable, medium easy to setup, and I would generally be grateful if everything worked as well as Patroni did.
But this was a fairly small Patroni installation on a fairly small K8S cluster (6 nodes), so YMMV.
Re: Oracle vs. PostgreSQL – A Comment
#14Copying from https://stackoverflow.com/questions/12115397/is-it-against-l... : The standard license ( http://www.oracle.com/technetwork/licenses/standard-license-... ) you agree to when you download software from the Oracle Technology Network (OTN) does state that you're not allowed to disclose benchmarks. You may not: > - disclose results of any program benchmark tests without our prior consent. I sadly suspect that…
What are the damage claims for something like this, if any? Surely neither side would want to litigate this.
Not damage claims. You are going against Larry Ellison, who is the boogey man of enterprise software.
The guy can spend money on a buying a Russian Mig29 fighter plane.
I am sure he can throw some money to make someones life a misery because he can.
Re: Oracle vs. PostgreSQL – A Comment
#15That's not a very useful comparison. Databases are made to execute queries, not to install them. The only useful metric is performance and features (and price, of course). Sure, Oracle is bloated and pain to manage, but if it works faster, provides unique features and costs less in the end, people will use it.
Re: Oracle vs. PostgreSQL – A Comment
#16Copying from https://stackoverflow.com/questions/12115397/is-it-against-l... : The standard license ( http://www.oracle.com/technetwork/licenses/standard-license-... ) you agree to when you download software from the Oracle Technology Network (OTN) does state that you're not allowed to disclose benchmarks. You may not: > - disclose results of any program benchmark tests without our prior consent. I sadly suspect that…
people have known this things for quite a while (ie as as far as perf goes oracle is not worth it) and there is a reason why oracle includes that in the license.
also, this comparison would not register as a proper “benchmark” as it’s not even close to how you would perform a proper benchmark. it’s more of a data point.
on top of that there is the optics of suing a guy that wrote an email over some insane provision in your license. probably not worth it. and probably that provision is there to stop competitors from doing an apples to apples comparison and publishing the results that show how much oracle sucks.
as a closing thought: i’ve never heard about anyone starting a new project and even considering oracle as a db for it. it’s mostly locked in people that have to put up with this stuff. legacy code is a bee
Re: Oracle vs. PostgreSQL – A Comment
#17Copying from https://stackoverflow.com/questions/12115397/is-it-against-l... : The standard license ( http://www.oracle.com/technetwork/licenses/standard-license-... ) you agree to when you download software from the Oracle Technology Network (OTN) does state that you're not allowed to disclose benchmarks. You may not: > - disclose results of any program benchmark tests without our prior consent. I sadly suspect that…
What are the damage claims for something like this, if any? Surely neither side would want to litigate this.
I'd love EFF to take this on and publish all the discovery findings.
Re: Oracle vs. PostgreSQL – A Comment
#18I'm a big fan of Postgres, and it's got plenty going for it. That's not to say Oracle isn't a good database in its own right. The knocks against Oracle tend to be lock-in, complexity, price, but rather than go in a checklist comparison I'd rather say what's unique about Postgres: - Based on its license it's very hard for any one company or individual to "own" Postgres, this makes risk of a company as a bad actor bein…
> Its geospatial capabilities put it as the most advanced geospatial database, only ESRI software really stands to beat it here
Where does PostGIS stand in comparison?
Re: Oracle vs. PostgreSQL – A Comment
#19>” create stand alone database: ~30m”
Something is oddly wrong in his tests if it took him 30 minutes to create an oracle database.
Re: Oracle vs. PostgreSQL – A Comment
#20Is vacuumin postgres still basically means that you need downtime?
Vacuuming is online, with some performance hit while it's underway.