Re: performance tuning in large function / transaction - Mailing list 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.