Re: [PERFORM] General key issues when comparing performance between PostgreSQL and oracle

2013-07-16 Thread Tom Lane
Scott Marlowe writes: > On Tue, Jul 16, 2013 at 10:51 AM, Brian Fehrle > wrote: >> I'm working on performance tuning a host of queries on PostgreSQL 9.2 from >> an application, each query having its own issues and fixes, however from >> what I understand this application runs the exact same queri

Re: [PERFORM] General key issues when comparing performance between PostgreSQL and oracle

2013-07-16 Thread Scott Marlowe
On Tue, Jul 16, 2013 at 10:51 AM, Brian Fehrle wrote: > Hi all (Hopefully this is the correct mailing list for this). > > I'm working on performance tuning a host of queries on PostgreSQL 9.2 from > an application, each query having its own issues and fixes, however from > what I understand this a

Re: [PERFORM] General key issues when comparing performance between PostgreSQL and oracle

2013-07-16 Thread Samuel Gendler
On Tue, Jul 16, 2013 at 9:51 AM, Brian Fehrle wrote: > > Are there any known differences between the database systems in terms of > query planners or general operations (sorting, unions) that are notable > different between the systems that would make postgres slow down when > executing the exact

[PERFORM] General key issues when comparing performance between PostgreSQL and oracle

2013-07-16 Thread Brian Fehrle
Hi all (Hopefully this is the correct mailing list for this). I'm working on performance tuning a host of queries on PostgreSQL 9.2 from an application, each query having its own issues and fixes, however from what I understand this application runs the exact same queries on the exact same dat