On 14 December 2012 13:48, Harvey Rothenberg <[email protected]> wrote: > Can you suggest any general configuration tips that would help in > the performance of the application
Yes. Analyse the performance issues in the application, not in the OS hosting the database. If you don't find low-hanging fruit in the app, you're not trying. Don't you think that if there really were a "fast = true" option (thanks Tom Kyte!) it would already be enabled? And this applies as much to the OS as to the RDBMS > Are there any installation hints that you can offer to help with the > performance and/or transferring of the data from the Oracle engine > to the PostgreSql engine ? You'll want to very carefully retest every part of your application to ensure that PG's approach to multi-version concurrency is compatible with Oracle's. This aspect of relational databases has not been standardised. Ignore at your peril. At the least you will have to document all of your app's concurrency assumptions. A useful exercise, I guess. There's a great discussion of this in Kyte's "Expert Oracle By Design" book. Recommended reading, even if you're migrating to another DBMS. Are you really going to save money by ditching Oracle? $EMP is also looking at migrating its app from Oracle to PG and the costs will be very, very high to do so. It's an extremely labour-intensive task. Merely getting your tables/triggers/stored procedures ported across is only the very beginning of the work. In our case the app has over 18000 SQL files totaling half a gigabyte, so even the beginning will be a large investment of time... and then there's the PL/SQL. And PG doesn't (as far as I'm aware) have an equivalent of many other Oracle features we use, eg. Advanced Queues. PG doesn't seem to have a real equivalent of Oracle Partitioning either, the PG version is quite hackish. I'm not a PG hater, by the way. It was the first RDBMS I learned, and is still a favourite. But I can appreciate the places where Oracle is the superior product. John
_______________________________________________ Discuss mailing list [email protected] https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss This list provided by the League of Professional System Administrators http://lopsa.org/
