Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d3wer-0001b5-Tx for pgsql-admin@arkaria.postgresql.org; Fri, 28 Apr 2017 03:33:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d3weq-0000H9-QU for pgsql-admin@arkaria.postgresql.org; Fri, 28 Apr 2017 03:33:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d3wep-0000Gm-7H for pgsql-admin@postgresql.org; Fri, 28 Apr 2017 03:33:23 +0000 Received: from mail-qt0-x232.google.com ([2607:f8b0:400d:c0d::232]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1d3weh-0007tD-6T for pgsql-admin@postgresql.org; Fri, 28 Apr 2017 03:33:22 +0000 Received: by mail-qt0-x232.google.com with SMTP id g60so41551381qtd.3 for ; Thu, 27 Apr 2017 20:33:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:reply-to:to:message-id:subject:mime-version:references :content-length; bh=lt9IJ8ctWAE/Ift/IYNB/eXYdp4VquXrUVprNepgYuY=; b=IdJ/TbuGwp6mfN2IYzUIKwxv14B2f8q6QFiKmMBFlTkVoj4kjMwfKIFzXizs86Abo8 GrUDPN8nwbAG4uxfBzGbpM34dViMLS/DEgX0TpNiwoSlbZVnV8tMm9FB4AjHypvuvGnX p0yrlAwrvtmVSe+q1gy7zzuQs7W7dHNAVpP/3FS8NOQoPs90fDE7yojsgmiKQq4c34CO UEO58qnkAqwFoMTqxbArxe7kd4St8PsB+NhIy1aGcdoaIjZlUvI5JmMbmfiSXj8gYzLy If54pZDWeDeLUAqae924+IvpGpU9jWMriLwmteRtZwlcedpVwKyux1fh+PdDijqdYHzF 2Q0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:reply-to:to:message-id:subject :mime-version:references:content-length; bh=lt9IJ8ctWAE/Ift/IYNB/eXYdp4VquXrUVprNepgYuY=; b=HvDx4QkFpPWocWxC8N3xx53Kvfo55sPmsZp5nYqaOOoPDL4DHrUfx39On3b4/couo9 87mDtAEV5FEKcRCIjY2XL5v3RXO8LLUONoP8KZimx0ffkCMitG15dS+YRIAH1uy4c0+X vXMgUlN9jbSXpy+7suWnrYbqAHmDxMCbrMR9EfyxchnqpAODDTb9xs2AD492gt0xRq9n c0bxe2nemO23ce2C6NKYk2Xl8uqXecEpSoJIeHXpFbLx7yYuvrdGT95I65CXs/ldJbwX F06rtzUy/IjYf8yUafJKPfJbGwU2IAIHNdJSztJnqzFKIec9NACO3gmIJJcrcGhzrpef eWLA== X-Gm-Message-State: AN3rC/4anKZ11rENWd+LIndRUo6FeUA2+Xpyk/rl505giCbYGqwt5HQC aDhuykjQqNcXy8MbhSk= X-Received: by 10.200.54.237 with SMTP id b42mr7864621qtc.233.1493350392394; Thu, 27 Apr 2017 20:33:12 -0700 (PDT) Received: from smtpsendws102.mail.bf1.yahoo.com (smtpsendws102.mail.bf1.yahoo.com. [66.196.81.112]) by smtp.gmail.com with ESMTPSA id g66sm2973170qkb.55.2017.04.27.20.33.11 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 27 Apr 2017 20:33:11 -0700 (PDT) X-YMail-OSG: jWPPP6wVM1mQkkdI5kMXBRhIxMABCn6NiF6ePnxEdZbVplHX.CzJfHvRT_XS1T9 E77kHY1Jer6fy88SB2UvBtTEWlGDZbk.ISqSt84eDchc6optHkwJMfCie9jMxi6Ir5.PgoLfwKiP NA7E8EVRpMbQuo4tfcvRKJn5HoO6JAV_ANSh1LI3SV9jTfrD_gL50W_HW7rxwPh0ZHlDogQKw2_U 546eGw.iOKC8xOoD9zvgiw8Ssgcu4hnc9WNdWhnRYvJAQKVjZTii.I0ORIgAM2uuGmMlaDCXofPq DodBH960yWA01otn12qoHbcwZLuGfQCtgfxzJ_pHtHyJUauBlz6QfJU_kkQa5R0oapNo9YeyeA4N 5ly0xBHfstduvZrDhm0JM1bkHAIJJ4yShMF8ytKHCKEg0.8KmvFEc1tSVhc7xdcFQu2H8Y1Sgu5P 5oGuBO13gHEv_AHLLMK2w677JAchm3rmTN9_hGZIOilh2etjsvb4skOKBrrMge6g8d1l2TyhQAM6 _c2KgRdpXFnElFF2A8hlAhSzF06cGuA-- Received: from jws400022.mail.bf2.yahoo.com by smtpsendws102.mail.bf1.yahoo.com; Fri, 28 Apr 2017 03:33:10 +0000; 1493350390.619 Date: Fri, 28 Apr 2017 03:32:45 +0000 (UTC) From: Suresh Rajagopal Reply-To: Suresh Rajagopal To: Pgsql-admin Message-ID: <1762877799.124696.1493350365134@mail.yahoo.com> Subject: wal segment size MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_124695_696636680.1493350365132" References: <1762877799.124696.1493350365134.ref@mail.yahoo.com> X-Mailer: WebService/1.1.9521 YahooMailNeo Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36 Content-Length: 1303 X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_124695_696636680.1493350365132 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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 ------=_Part_124695_696636680.1493350365132 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
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
------=_Part_124695_696636680.1493350365132--