pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwal segment size
3+ messages / 3 participants
[nested] [flat]
* wal segment size
@ 2017-04-28 03:32 Suresh Rajagopal <sureshr7@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Suresh Rajagopal @ 2017-04-28 03:32 UTC (permalink / raw)
To: pgsql-admin
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.3OS: Centos 6.6
ThanksSuresh
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: wal segment size
@ 2017-04-28 11:43 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Suresh Rajagopal <sureshr7@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2017-04-28 11:43 UTC (permalink / raw)
To: Suresh Rajagopal <sureshr7@gmail.com>; 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: wal segment size
@ 2017-05-12 09:25 Steven Chang <stevenchang1213@gmail.com>
parent: Suresh Rajagopal <sureshr7@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Steven Chang @ 2017-05-12 09:25 UTC (permalink / raw)
To: Suresh Rajagopal <sureshr7@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2017-05-12 09:25 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-04-28 03:32 wal segment size Suresh Rajagopal <sureshr7@gmail.com>
2017-04-28 11:43 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2017-05-12 09:25 ` Steven Chang <stevenchang1213@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox