Re: Tuning queries on large database

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Tuning queries on large database
Дата
Msg-id 41110220.7000006@bigfoot.com
обсуждение исходный текст
Ответ на Tuning queries on large database  (Valerie Schneider DSI/DEV <Valerie.Schneider@meteo.fr>)
Список 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 по дате отправления:

Предыдущее
От: Jesper Krogh
Дата:
Сообщение: Re: pg_dump performance?
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: [GENERAL] Tuning queries on large database