X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 555EB9DC83A
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  7 Mar 2006 12:57:45 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 69719-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  7 Mar 2006 12:57:42 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from web53209.mail.yahoo.com (web53209.mail.yahoo.com
	[206.190.49.79]) by postgresql.org (Postfix) with SMTP id D63DE9DC851
	for <pgsql-performance@postgresql.org>;
	Tue,  7 Mar 2006 12:57:41 -0400 (AST)
Received: (qmail 72852 invoked by uid 60001); 7 Mar 2006 16:57:39 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=1yeLke0LlQ8FIVhybiJRBp/faJ6HytBnVYh1vrK6nuZf9rAWS0D3Pc6eI3dwXgJIkiu84+RniKJuONu668p9Z+UQK21odsitiZLHZ2RCFiMBCKmhl/wfLmYt9S0N6qAaqCVQ7e8BqpnRZcJtMFPqNRgaru7r4FECJLSVHLIKo6w=
	;
Message-ID: <20060307165739.72850.qmail@web53209.mail.yahoo.com>
Received: from [201.35.218.73] by web53209.mail.yahoo.com via HTTP;
	Tue, 07 Mar 2006 13:57:39 ART
Date: Tue, 7 Mar 2006 13:57:39 -0300 (ART)
From: Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
Subject: Re: firebird X postgresql 8.1.2 windows, performance comparison
To: pgsql-performance@postgresql.org
In-Reply-To: <20060307162842.M37264@techforce.com.br>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-142276793-1141750659=:71939"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200603/61
X-Sequence-Number: 17498

--0-142276793-1141750659=:71939
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Andre,
   
  I noticed that enable_bitmapscan and enable_seqscan are off, is there a reason for it? Have you tried with enable_bitmapscan on?
   
  How much RAM do you have? What kind of disks are being used?
   
  Beste regards,
   
  Reimer
  55-47-33270878
  Blumenau - SC - Brazil
  
andremachado <andremachado@techforce.com.br> escreveu:
  Hello,
A friend asked for help to accelerate some postgresql queries on postgresql
8.1.2 for windows.
He is comparing with firebird.
Firebird was being up to 90 times faster at some queries.
Attached is a gziped text file containing some steps I tried on a simple
example query.
Could get improvements from 270 seconds to 74 seconds.
But Firebird effortlessly still can perform the same query at 20 seconds.
Please, do you have some suggestion?
Thanks.
Andre Felipe Machado


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


		
---------------------------------
 Yahoo! Acesso Grátis 
Internet rápida e grátis. Instale o discador agora!
--0-142276793-1141750659=:71939
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>Andre,</DIV>  <DIV>&nbsp;</DIV>  <DIV>I noticed that enable_bitmapscan and enable_seqscan are off, is there a reason for it? Have you tried with enable_bitmapscan on?</DIV>  <DIV>&nbsp;</DIV>  <DIV>How much RAM do you have? What kind of disks are being used?</DIV>  <DIV>&nbsp;</DIV>  <DIV>Beste regards,</DIV>  <DIV>&nbsp;</DIV>  <DIV>Reimer</DIV>  <DIV>55-47-33270878</DIV>  <DIV>Blumenau - SC - Brazil</DIV>  <DIV><BR><B><I>andremachado &lt;andremachado@techforce.com.br&gt;</I></B> escreveu:</DIV>  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hello,<BR>A friend asked for help to accelerate some postgresql queries on postgresql<BR>8.1.2 for windows.<BR>He is comparing with firebird.<BR>Firebird was being up to 90 times faster at some queries.<BR>Attached is a gziped text file containing some steps I tried on a simple<BR>example query.<BR>Could get improvements from 270 seconds to 74 seconds.<BR>But Firebird effortless
 ly still
 can perform the same query at 20 seconds.<BR>Please, do you have some suggestion?<BR>Thanks.<BR>Andre Felipe Machado<BR><BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 1: if posting/reading through Usenet, please send an appropriate<BR>subscribe-nomail command to majordomo@postgresql.org so that your<BR>message can get through to the mailing list cleanly<BR></BLOCKQUOTE><BR><p>
		<hr size=1> 
Yahoo! Acesso Grátis <br>
Internet rápida e grátis. <a href="http://us.rd.yahoo.com/mail/br/tagline/homepage_set/*http://br.acesso.yahoo.com">Instale o discador agora!</a>
--0-142276793-1141750659=:71939--