X-Original-To: pgsql-performance@postgresql.org Received: from hm61.locaweb.com.br (hm61.locaweb.com.br [200.213.197.161]) by postgresql.org (Postfix) with SMTP id AE9874758E6 for ; Wed, 12 Mar 2003 15:49:02 -0500 (EST) Received: (qmail 17969 invoked from network); 12 Mar 2003 20:51:27 -0000 Received: from hm20.locaweb.com.br (200.246.179.120) by hm61.locaweb.com.br with QMTP; 12 Mar 2003 20:51:27 -0000 Received: (qmail 11721 invoked from network); 12 Mar 2003 20:50:56 -0000 Received: from unknown (HELO fabio) (contato@enix.com.br@200.207.117.104) by hm20.locaweb.com.br with SMTP; 12 Mar 2003 20:50:56 -0000 Message-ID: <000701c2e8d8$95637b60$02ada8c0@enix> From: =?iso-8859-1?Q?Enix_Empreendimentos_e_Constru=E7=F5es_Ltda.?= To: Subject: Postgresql performance Date: Wed, 12 Mar 2003 17:47:23 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Archive-Number: 200303/81 X-Sequence-Number: 1379 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