From: Enix Empreendimentos e Construções Ltda. <contato@enix.com.br>
To: pgsql-performance@postgresql.org
Subject: Postgresql performance
Date: Wed, 12 Mar 2003 17:47:23 -0300
Message-ID: <000701c2e8d8$95637b60$02ada8c0@enix> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: contato@enix.com.br
Subject: Re: Postgresql performance
In-Reply-To: <000701c2e8d8$95637b60$02ada8c0@enix>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox