Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b9Bo2-0006XA-34 for pgsql-performance@arkaria.postgresql.org; Sat, 04 Jun 2016 13:40:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b9Bo0-0004px-Ld for pgsql-performance@arkaria.postgresql.org; Sat, 04 Jun 2016 13:40:00 +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 1b9Bo0-0004pq-5I for pgsql-performance@postgresql.org; Sat, 04 Jun 2016 13:40:00 +0000 Received: from mail-oi0-x22c.google.com ([2607:f8b0:4003:c06::22c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b9Bnr-0003oi-Ex for pgsql-performance@postgresql.org; Sat, 04 Jun 2016 13:39:59 +0000 Received: by mail-oi0-x22c.google.com with SMTP id k23so166726760oih.0 for ; Sat, 04 Jun 2016 06:39:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=yz0xfGLUzH+kj6/4fdM2y9gQ4hvlFdwyxsY8HhZ6SIY=; b=V46OFWopCaTLmnqpRgxx7vxpNG3iWy5dMBVtb5UhhNU2tD+s9b7ja8NcNsHO0ToBhW 77pFngGmLbok2JJITdI/B7rl7EddN2QCqkcc0xvzhANxxo/+SFMPWOqTT+MeG1iM3PWU qjStQU8lnGUbEQwKG0RM5nNfHYhWmVYGQuDXDU9FeSuT0GraMmGk4dAxaLRe14qTg6Ev G91OVkLa7EMrHR18cPJsFgleVb1F7eDALFi3MwBK9S4ULru4ZNGVTd62foR/pMVCRBbh U22H7XO+gSwUA5jdu1Ybm+quvhNI1SRRaCyd3aq45wuwZ2MO3Vbm5B8+fClCz4sbe4+D 2TqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=yz0xfGLUzH+kj6/4fdM2y9gQ4hvlFdwyxsY8HhZ6SIY=; b=aJIS4VBn8BY2RaLd9JH0qoKR2v4sHoPBu2c0TvRInCXtPHJsRmg2iwS2W1eDWdHffa e8dpi2+JXEab32KaPvb5RkWYV7Lwx7ga7dwdPhGIeAC43sEPQ8ZXoeu+uzXr5VMDrWQC HWSse/19hQr/SKAXH5ObBvARxpc4ucbTMjDH3SX2So+ZxAz2Gm73nEP+65XSt1ajbFYp 1NzqCVKpkGdH4EmJI0mnQdjz0NtljLuPN54XFd42XHlUuTpX5MtW7JqfT/Cdz/uJVGvx nMppmCejS+HTXZ1Fr6qHmD3dcXT5F23CtWSj2HU2MVN9UV6VKJnC+nZ1aDs+bpUiRy1T SIXA== X-Gm-Message-State: ALyK8tL0rvkqBxRmJFI1iOWNfqcToFBnAJYeXZdxt+gXb949LYtacaum1XMSXP7g/wDbWvEJWMKQuC4wT4t8Zw== X-Received: by 10.157.5.3 with SMTP id 3mr4067223otw.182.1465047589201; Sat, 04 Jun 2016 06:39:49 -0700 (PDT) MIME-Version: 1.0 Received: by 10.182.19.133 with HTTP; Sat, 4 Jun 2016 06:39:48 -0700 (PDT) In-Reply-To: <20160603235406.GN23616@telsasoft.com> References: <20160524173914.GA11880@telsasoft.com> <20160525140034.GB21220@telsasoft.com> <20160603235406.GN23616@telsasoft.com> From: Kevin Grittner Date: Sat, 4 Jun 2016 08:39:48 -0500 Message-ID: Subject: Re: index fragmentation on insert-only table with non-unique column To: Justin Pryzby Cc: "pgsql-performance@postgresql.org" Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Fri, Jun 3, 2016 at 6:54 PM, Justin Pryzby wrote: > max_wal_size | 4GB | configuration file > min_wal_size | 6GB | configuration file Just a minor digression -- it generally doesn't make sense to configure the minimum for something greater than the maximum for that same thing. That should have no bearing the performance issue raised on the thread, but you might want to fix it anyway. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance