[PERFORM] Tuning queries on large database

2004-08-04 Thread Valerie Schneider DSI/DEV
Hi, I have some problem of performance on a PG database, and I don't know how to improve. I Have two questions : one about the storage of data, one about tuning queries. If possible ! My job is to compare Oracle and Postgres. All our operational databases have been running under Oracle for about

Re: [PERFORM] Tuning queries on large database

2004-08-04 Thread Valerie Schneider DSI/DEV
X-Original-To: [EMAIL PROTECTED] X-Authentication-Warning: houston.familyhealth.com.au: chriskl owned process doing -bs Date: Wed, 4 Aug 2004 21:21:51 +0800 (WST) From: Christopher Kings-Lynne [EMAIL PROTECTED] To: Valerie Schneider DSI/DEV [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], [EMAIL

Re: [GENERAL] [PERFORM] Tuning queries on large database

2004-08-05 Thread Valerie Schneider DSI/DEV
process doing -bs Date: Wed, 4 Aug 2004 21:21:51 +0800 (WST) From: Christopher Kings-Lynne [EMAIL PROTECTED] To: Valerie Schneider DSI/DEV [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [GENERAL] [PERFORM] Tuning queries on large database MIME-Version: 1.0 X-Virus-Scanned