[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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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