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

[PERFORMANCE] how to set wal_buffers

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: psql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: [PERFORMANCE] how to set wal_buffers
Date: 2009-08-20 00:25:11
Message-ID: 3073cc9b0908191725i7cdf8f72mc495e636d85222f7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

Our fine manual says:
"""
The amount of memory used in shared memory for WAL data. The default
is 64 kilobytes (64kB). The setting need only be large enough to hold
the amount of WAL data generated by one typical transaction, since the
data is written out to disk at every transaction commit. This
parameter can only be set at server start.
"""

but how can measure "one typical transaction"? i read in the archives
that the useful top for this parameter is 1MB is that an "oficial"
opinion?
while we are there is there any way to know how many transactions are
we processing per period of time?

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

pgsql-performance by date

Next:From: Jaime CasanovaDate: 2009-08-20 00:45:28
Subject: [PERFORMANCE] work_mem vs temp files issue
Previous:From: Kevin KempterDate: 2009-08-19 17:37:58
Subject: Re: Query tuning

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