From: David Brown <time@bigpond.net.au>
To: Andre Felipe Machado <andremachado@techforce.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: firebird X postgresql 8.1.2 windows, performance comparison
Date: Fri, 10 Mar 2006 09:51:36 +1000
Message-ID: <4410BF88.5080001@bigpond.net.au> (raw)
In-Reply-To: <1141782015.1610.40.camel@localhost.localdomain>
References: <20060307162842.M37264@techforce.com.br>
<1141782015.1610.40.camel@localhost.localdomain>
Andre Felipe Machado wrote:
>It seems that Firebird windows can use adequately as much ram it finds
>and postgresql windows can not.
>
>
PostgreSQL relies on the OS cache to utilize RAM. Make sure that most of
the RAM is 'available' so Windows can do its thing.
effective_cache_size should be set correspondingly high - at least 65535.
shared_buffers should be as low as you can get away with (allowing for
multiple users). 16384 is 12.5% of your RAM and far too high.
AFAIK, PostgreSQL still doesn't differentiate between index blocks and
data blocks.
>work_mem reduced time almost 66%.
>But work_mem easily can exhaust ram with many users connected, as each
>connection query will use this amount of memory (if I can remember).
>How much it can grow at this 1 gbram win machine?
>
>
work_mem has to be just big enough to allow hash joins to operate
efficiently. This varies from query to query and can be set in your code
accordingly. However, the 1024 default is just too low for most
applications and you'll probably find even 4096 is a huge improvement.
You need to find the minimum that delivers acceptable performance in
most queries and boost it for selected queries as required.
BTW, which version of Firebird is this?
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: time@bigpond.net.au, andremachado@techforce.com.br
Subject: Re: firebird X postgresql 8.1.2 windows, performance comparison
In-Reply-To: <4410BF88.5080001@bigpond.net.au>
* 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