public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kevin Grittner <[email protected]>
To: Justin Pryzby <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: index fragmentation on insert-only table with non-unique column
Date: Sat, 4 Jun 2016 08:39:48 -0500
Message-ID: <CACjxUsMS9zu=WT5TjoEwrb4v6rb-HNqSgA-WL7wsuxRbuR8Ttw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<CAMkU=1wsSEgByzYQ5uazD1gSsJh9RRYME6ehgJsUp3XcMm2Djg@mail.gmail.com>
<[email protected]>
<CAGTBQpbqkQYRbnz-7MJEhCL9bRhaE3sX12LZh4YGh4m+xoUqYA@mail.gmail.com>
<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
On Fri, Jun 3, 2016 at 6:54 PM, Justin Pryzby <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: index fragmentation on insert-only table with non-unique column
In-Reply-To: <CACjxUsMS9zu=WT5TjoEwrb4v6rb-HNqSgA-WL7wsuxRbuR8Ttw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox