[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] wal segment size
From:       Steven Chang <stevenchang1213 () gmail ! com>
Date:       2017-05-12 9:25:00
Message-ID: CAEJt7k3yoh9f8UAmWWmyXmmaxcJePGk=uuo2=S4xRs-bakQ29A () mail ! gmail ! com
[Download RAW message or body]

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
>

[Attachment #3 (text/html)]

<div dir="ltr">Hi,<div><br></div><div>        I don&#39;t think you can change it \
.</div><div>        It&#39;s<span \
style="color:rgb(0,0,0);font-family:verdana,sans-serif;font-size:medium">  read-only, \
and are determined when  </span><span class="gmail-PRODUCTNAME" \
style="color:rgb(0,0,0);font-family:verdana,sans-serif;font-size:medium">PostgreSQL</span><span \
style="color:rgb(0,0,0);font-family:verdana,sans-serif;font-size:medium">  is \
compiled or when it is installed.</span></div><div><span \
style="color:rgb(0,0,0);font-family:verdana,sans-serif;font-size:medium">     \
What&#39;s your real problem about WAL ??</span></div><div><br></div><div><font \
color="#000000" face="verdana, sans-serif" size="3">Regards,</font></div><div><font \
color="#000000" face="verdana, sans-serif" size="3">Steven</font></div><div><span \
style="color:rgb(0,0,0);font-family:verdana,sans-serif;font-size:medium"><br></span></div><div><span \
style="color:rgb(0,0,0);font-family:verdana,sans-serif;font-size:medium"><br></span></div></div><div \
class="gmail_extra"><br><div class="gmail_quote">2017-04-28 11:32 GMT+08:00 Suresh \
Rajagopal <span dir="ltr">&lt;<a href="mailto:sureshr7@gmail.com" \
target="_blank">sureshr7@gmail.com</a>&gt;</span>:<br><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div \
style="color:#000;background-color:#fff;font-family:lucida \
console,sans-serif;font-size:16px"><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228">Hi,</div><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228"><br></div><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228">Is there any \
recommendation for wal_segment_size for an active database generating almost 2400 \
files per day with default 16MB file size?</div><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228"><br></div><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228">Postgres Version: \
9.3</div><div id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228">OS: \
Centos 6.6</div><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228"><br></div><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228">Thanks</div><span \
class="HOEnZb"><font color="#888888"><div \
id="m_-3975508065094614912yui_3_16_0_ym19_1_1493340036280_22228">Suresh</div></font></span></div></div></blockquote></div><br></div>




[prev in list] [next in list] [prev in thread] [next in thread]