From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | andremachado <andremachado(at)techforce(dot)com(dot)br> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: firebird X postgresql 8.1.2 windows, performance comparison |
Date: | 2006-03-07 16:44:13 |
Message-ID: | 440DB85D.2040804@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)postgresql(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Henrique Reimer | 2006-03-07 16:57:39 | Re: firebird X postgresql 8.1.2 windows, performance comparison |
Previous Message | andremachado | 2006-03-07 16:29:22 | firebird X postgresql 8.1.2 windows, performance comparison |