X-Original-To: pgsql-performance@postgresql.org
Received: from utahisp.com (mail.cyber-wire.com [66.239.12.3])
	by postgresql.org (Postfix) with ESMTP id 9B79B4769F8
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Mar 2003 16:38:15 -0500 (EST)
Received: from chad [63.230.8.76] by utahisp.com
	(SMTPD32-7.14) id A84DBC59027E; Wed, 12 Mar 2003 14:36:13 -0700
Message-ID: <0c8a01c2e8df$b205a2a0$32021aac@chad>
From: "Chad Thompson" <chad@weblinkservices.com>
To: =?iso-8859-1?Q?Enix_Empreendimentos_e_Constru=E7=F5es_Ltda.?=
	<contato@enix.com.br>, <pgsql-performance@postgresql.org>
References: <000701c2e8d8$95637b60$02ada8c0@enix>
Subject: Re: Postgresql  performance
Date: Wed, 12 Mar 2003 14:38:16 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Declude-Sender: chad@weblinkservices.com [63.230.8.76]
X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for
 spam.
X-Archive-Number: 200303/82
X-Sequence-Number: 1380

There are a lot of things that can be done to speed up your queries.
Especially if you are using the kludge that Access puts out.  Post some of
them and we can help.

As far as the difference between 7.1.3 and 7.3.2 there are a lot of
optimizations as well as bug fixes, its always a good idea to upgrade.

HTH
Chad
----- Original Message -----
From: "Enix Empreendimentos e Construções Ltda." <contato@enix.com.br>
To: <pgsql-performance@postgresql.org>
Sent: Wednesday, March 12, 2003 1:47 PM
Subject: [PERFORM] Postgresql 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>