| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | Valerie Schneider DSI/DEV <Valerie(dot)Schneider(at)meteo(dot)fr> |
| Subject: | Re: Tuning queries on large database |
| Date: | 2004-08-04 15:34:56 |
| Message-ID: | 41110220.7000006@bigfoot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre-Frédéric Caillaud | 2004-08-04 15:50:56 | Re: Tuning queries on large database |
| Previous Message | Robert Treat | 2004-08-04 15:17:58 | Re: Where are all the users? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Adler | 2004-08-04 15:36:24 | Re: Performance Bottleneck |
| Previous Message | Gaetano Mendola | 2004-08-04 15:29:48 | Re: The black art of postgresql.conf tweaking |