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 03:02:05
Message-ID: 20011213185555.D6476-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 13 Dec 2001, MindTerm wrote:

> I am writing a function (plpgsql) which equals to a
> single transaction transaction in postgresql ( as I
> known ). So I think that it is not a autocommmit mode.
>
> I have add following lines in postgresql.conf.
>
> postgresql.conf:
> ====================
> shared_buffers = 640
> wal_buffers = 80

It depends on how much memory you have, but even 640 is pretty
low (I think that works out to 5M). Probably a few thousand
is better if you've got the ram.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message MindTerm 2001-12-14 03:34:28 Re: performance tuning in large function / transaction
Previous Message MindTerm 2001-12-14 02:46:52 Re: performance tuning in large function / transaction