Re: wal segment size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Suresh Rajagopal <sureshr7@xxxxxxxxx>
Subject: Re: wal segment size
From: Steven Chang <stevenchang1213@xxxxxxxxx>
Date: Fri, 12 May 2017 17:25:00 +0800
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com; spf=pass (google.com: best guess record for domain of pgsql-admin-owner+m46642=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-admin-owner+M46642=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:cc:to:subject:message-id :date:from:references:in-reply-to:mime-version:dkim-signature :arc-authentication-results; bh=nKDg8jwY91opSyiHY7iQC86WDRKiQ4z6ZzBs5ibOn+E=; b=CC1od5mlcxGwYqSIzMsyKDLTv1LLeSwjCeN2TToPLFvc4rJKatwSUkH+Kf6QNSQxeP Mvozt9DR4VgTpoPIQvGz8U+oZ12L9pzd6qurP8tOy69ShlBamenRWVCM6BYSSMRGHgOj T5WHcJZnH1RHmBIxdHX5hh7yrA7AmY3XDcF+6RK1IjMvyqLyqHHBYYrq9+ymquf1iOYo S2SwkGqYo5WHhiw8qieJrTy9fbAu5ufPmIkwAeR2wJICXHSW0NVaRJNFWQIb9tUBqJVg r0gq5y652mUIFrTxO9FpAgKkbK3TrQhIpnzhySzx0WKtXeLXqWfsFctVQY5qdtudh4DN zucA==
Arc-seal: i=1; a=rsa-sha256; t=1494581145; cv=none; d=google.com; s=arc-20160816; b=AlvjeDixVN1pE/hIc+J6MGYASlXfckDxxVk/8+OVWRBv/EXO56d8JxcxVA5upRH4uh cpxrfToZTq68d+Ne8PTi02Tz4LZODb0qAIA4Uayj6xPXoyt3aJ90fB+ozCU4ayBXk7x5 fGTyhAz0HbkLwTXlB4g0/FnaMRbhyVRKGIsQRkMZtA8731Pcm/TkHniexBigSytEFR2l VoqiaQ86kljbpkEkAPB6Us6bN37aWCPHYDaiWSwNeHKu8WB3q8g9B/vCgsiax7N7/spj VW0Djvs74tXKfPTMyeKZPqu3/w4PC0HxpkkZFd7ZNgTfKLubCpaU4C+na8XkF2FpZhp5 yyyg==
Cc: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <1762877799.124696.1493350365134@mail.yahoo.com>
References: <1762877799.124696.1493350365134.ref@mail.yahoo.com> <1762877799.124696.1493350365134@mail.yahoo.com>

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@xxxxxxxxx>:

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

References:
- wal segment size
  - From: Suresh Rajagopal

Prev by Date: exporting query result
Next by Date: Re: postgres pg_basebackup
Previous by thread: Re: wal segment size
Next by thread: Memory consumption of a sql.
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]