Postgresql performance

Поиск
Список
Период
Сортировка
От Enix Empreendimentos e Construções Ltda.
Тема Postgresql performance
Дата
Msg-id 000701c2e8d8$95637b60$02ada8c0@enix
обсуждение исходный текст
Ответы Re: Postgresql performance  (Rod Taylor <rbt@rbt.ca>)
Re: Postgresql performance  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-performance
Hi everybody.

I am a newbie to Postgresql, trying to migrate an application from MSAccess.

I am quite dissapointed with the problems I am facing with some queries
containing multiple joins. I confess it has been hard for someone that is
not a DBA to figure out which are the problems. Just to ilustrate, I have
some queries that provide a reasonable query plan (at least from my point of
view), but that return no result: keep running on and on.

My system description is: Postgresql 7.1.3, Linux RedHat 7.1 (all patches
applied), 160Mb RAM.

Is the performance of the mentioned Postgresql version much slower than the
7.3.1?

All advice will be more than appeciated.

Regards.

Fabio


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.461 / Virus Database: 260 - Release Date: 10/03/2003


В списке pgsql-performance по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Large difference between elapsed time and run time
Следующее
От: "Chad Thompson"
Дата:
Сообщение: Re: Postgresql performance