Re: wal segment size

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: 'Suresh Rajagopal' <sureshr7(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: wal segment size
Date: 2017-04-28 11:43:23
Message-ID: A737B7A37273E048B164557ADEF4A58B53A2E644@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Suresh Rajagopal wrote:
> Is there any recommendation for wal_segment_size for an active database generating almost
> 2400 files per day with default 16MB file size?

That averages to less than two per minute, doesn't sound so bad.

I'd be reluctant to change the default value - there is little experience with
other values.

Do you have a problem with 16MB WAL files?

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ajlinux 2017-04-28 12:09:57 Repmgr and pg_dump conflict when backing up from standby
Previous Message Steven Chang 2017-04-28 07:15:08 Re: Memory consumption of a sql.