From: Joshua D. Drake <jd@commandprompt.com>
To: andremachado <andremachado@techforce.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: firebird X postgresql 8.1.2 windows, performance comparison
Date: Tue, 07 Mar 2006 08:44:13 -0800
Message-ID: <440DB85D.2040804@commandprompt.com> (raw)
In-Reply-To: <20060307162842.M37264@techforce.com.br>
References: <20060307162842.M37264@techforce.com.br>
andremachado wrote:
> 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.
>
Try increasing your work mem and shared buffers considerably.
Sincerely,
Joshua D. Drake
> 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
>
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/
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: jd@commandprompt.com, andremachado@techforce.com.br
Subject: Re: firebird X postgresql 8.1.2 windows, performance comparison
In-Reply-To: <440DB85D.2040804@commandprompt.com>
* 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