Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group