-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Freitag, 4. Januar 2013 21:41
To: Heikki Linnakangas
Cc: Daniel Westermann; 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] FW: performance issue with a 2.5gb joinded table
Heikki Linnakangas wri
-Original Message-
From: Heikki Linnakangas [mailto:hlinnakan...@vmware.com]
Sent: Donnerstag, 3. Januar 2013 18:02
To: Daniel Westermann
Cc: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] FW: performance issue with a 2.5gb joinded table
On 03.01.2013 15:30, Daniel
Hi Listers,
we migrated an oracle datawarehouse to postgresql 9.1 ( ppas 9.1.7.12 ) and are
facing massive issues with response times in postgres when compared to the
oracle system. Both database run on the same hardware and storage ( rhel5.8
64bit ).
Oracle memory parameters are:
SGA=1gb
PGA=
