Re: performance tuning in large function / transaction

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: MindTerm <mindterm(at)yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: performance tuning in large function / transaction
Date: 2001-12-14 06:47:26
Message-ID: 20011213224623.E8240-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Carolyn Lu Wong 2001-12-14 07:29:18 weird duplicate data problem
Previous Message Stephan Szabo 2001-12-14 06:42:20 Re: performance tuning in large function / transaction