81–90 of 94 posts
Meanwhile PostgresPro (extended PostgreSQL version, distributed by Oleg Bartunov's company "Postgres Professional") officially included to the Russian Software Registry: https://reestr.minsvyaz.ru/reestr/65273/ [ru]
~~ Nikolay Samokhvalov
Earlier quoted context omitted.
What's wrong with the current book? This is what we are reading : Database Systems: Design, Implementation, & Management 11th Edition
Anything that uses MySQL as a teaching example is just plain wrong.
Earlier quoted context omitted.
The main advantage Oracle has over SQL Server in my opinion is that Oracle has tablespaces and multi-version concurrency control baked in, whereas SQL Server has ONE TempDB and snapshot isolation relying on that one TempDB.
As a PostgreSQL user I dread the idea of running a database without MVCC, even MySQL and SQLite have decent MVCC support.
Earlier quoted context omitted.
I work for a major bank and Oracle is on its way out here. Trouble is, when it's running your general ledger and is tightly coupled to your core banking operations, migration to another platform can be a decade-long process.
Yeah, but on the bright side once your excised Oracle and replaced it with something better Oracle won't be coming back any time soon :-)
Earlier quoted context omitted.
> it can often be hard to find people who can troubleshoot performance issues. Even highly skilled people face a black box when they work on improving query performance as the CBO is largely a black box that can change from version to version. Without a clear explanation of how the CBO actually makes decisions it's often a bit of a crapshoot when tuning queries. This has not been my experience.
What part of parent has not been your experience ? I have experience parent's woes and more. That includes having Oracle staff in house doing in-person knowledge transfer. Experience says that Oracle will not provide a qualified person if we call for one as well. Sourcing from their own consultant pool is also a black box crap-shoot. We also involved Dell and their support team to provide feedback and second opinion…
We have several people in house (I know of 6) who can troubleshoot performance issues. For them the CBO is not a black box and they can explain what is happening and why.
I know of a local consulting company that has several very good people that you can "order". Said consulting company also offers very good CBO courses/workshops.
Earlier quoted context omitted.
What part of parent has not been your experience ? I have experience parent's woes and more. That includes having Oracle staff in house doing in-person knowledge transfer. Experience says that Oracle will not provide a qualified person if we call for one as well. Sourcing from their own consultant pool is also a black box crap-shoot. We also involved Dell and their support team to provide feedback and second opinion…
> What part of parent has not been your experience ? We have several people in house (I know of 6) who can troubleshoot performance issues. For them the CBO is not a black box and they can explain what is happening and why. I know of a local consulting company that has several very good people that you can "order". Said consulting company also offers very good CBO courses/workshops.
I doubt your in house experts fully understand the Oracle CBO. They may claim they do, but unless they have access to material that isn't public they can't possibly be able to diagnose the CBO fully.
You realise there are over a thousand hidden database parameters, right?
Earlier quoted context omitted.
+1 We have been building/rebuilding our applications on top of PostgreSQL but there are still a lot of departments that buy the "Oracle is better / We need paid support" propaganda. Props to Russia for their forward thinking views.
You can get paid support with Postgres : http://www.enterprisedb.com/products-services-training/subsc...
Earlier quoted context omitted.
Anything that uses MySQL as a teaching example is just plain wrong.
Why? It demos the basic concepts fine. Maybe they can use MariaDB instead?
Earlier quoted context omitted.
As a PostgreSQL user I dread the idea of running a database without MVCC, even MySQL and SQLite have decent MVCC support.
Postgres MVCC is anything but decent. It will take over control of the main heap. Good luck tackling that.
Oracle stores the old version of the row in a rollback segment.
According to the following article, "only changed values are written to undo whereas PostgreSQL/SQL Server creates a complete new tuple for modified row. This avoids bloat in the main heap segment." [1]
1. http://www.enterprisedb.com/postgres-plus-edb-blog/amit-kapi...