Postgres Pro
Downloads
Home   >   mailing lists

Thread: [ADMIN] wal segment size

[ADMIN] wal segment size

From
Suresh Rajagopal
Date:
Hi,

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

Postgres Version: 9.3
OS: Centos 6.6

Thanks
Suresh

Re: [ADMIN] wal segment size

From
Albe Laurenz
Date:
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

Re: [ADMIN] wal segment size

From
Steven Chang
Date:
Hi,

     I don't think you can change it .
     It's read-only, and are determined when PostgreSQL is compiled or when it is installed.
   What's your real problem about WAL ??

Regards,
Steven



2017-04-28 11:32 GMT+08:00 Suresh Rajagopal <sureshr7@gmail.com>:
Hi,

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

Postgres Version: 9.3
OS: Centos 6.6

Thanks
Suresh