Horton

Re: performance tuning in large function / transaction

Stephan Szabo <sszabo@megazone23.bigpanda.com>

View thread View on postgr.es
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: MindTerm <mindterm@yahoo.com>
Cc: <pgsql-sql@postgresql.org>
Date: 2001-12-14T06:47:26Z
Lists: pgsql-sql 
On Thu, 13 Dec 2001, MindTerm wrote:

> Hi all,
>
>   I will try to assign more memory to shared memory,
> say 50M ~ 100M .

Forgot to mention.  This depends on how much memory you've
actually got in the machine, but keep a bunch for backend
local memory stuff and system disk caching too.  Going too
high on shared memory can also be bad.