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

Re: [PERFORM] Hstore VS. JSON

2013-07-16 Thread Merlin Moncure
On Tue, Jul 16, 2013 at 10:33 AM, Andrew Dunstan wrote: > > On 07/16/2013 11:05 AM, Niels Kristian Schjødt wrote: >> >> Hi, >> >> I'm in the process of implementing a table for storing some raw data in >> the format of a hash containing one level of keys and values. The hash can >> be quite big (u

Re: [PERFORM] Hstore VS. JSON

2013-07-16 Thread Andrew Dunstan
On 07/16/2013 11:05 AM, Niels Kristian Schjødt wrote: Hi, I'm in the process of implementing a table for storing some raw data in the format of a hash containing one level of keys and values. The hash can be quite big (up to 50 keys pointing at values varying from one to several hundred char

[PERFORM] Hstore VS. JSON

2013-07-16 Thread Niels Kristian Schjødt
Hi, I'm in the process of implementing a table for storing some raw data in the format of a hash containing one level of keys and values. The hash can be quite big (up to 50 keys pointing at values varying from one to several hundred characters) Now, I'm in doubt whether to use JSON or Hstore