Re: Tuning queries on large database - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: Tuning queries on large database
Date
Msg-id 41110220.7000006@bigfoot.com
Whole thread Raw
In response to Tuning queries on large database  (Valerie Schneider DSI/DEV <Valerie.Schneider@meteo.fr>)
List pgsql-performance
Valerie Schneider DSI/DEV wrote:

> 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 fifteen years. Now I try to replace
> Oracle by Postgres.

Show us the explain analyze on your queries.

Regards
Gaetano Mendola





pgsql-performance by date:

Previous
From: Jesper Krogh
Date:
Subject: Re: pg_dump performance?
Next
From: Gaetano Mendola
Date:
Subject: Re: [GENERAL] Tuning queries on large database