From: Justin Pryzby <pryzby@telsasoft.com>
To: Gunther <raj@gusw.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
Date: Thu, 14 Mar 2019 10:54:56 -0500
Message-ID: <20190314155456.GG6030@telsasoft.com> (raw)
In-Reply-To: <b49c6a04-caaf-a3d1-4f07-978558260cf8@gusw.net>
References: <b49c6a04-caaf-a3d1-4f07-978558260cf8@gusw.net>
On Wed, Mar 13, 2019 at 02:44:10PM -0400, Gunther wrote:
> You see that I already did a lot to balance IO out to many different
> tablespaces that's why there are so many volumes.
I wonder if it wouldn't be both better and much easier to have just 1 or 2
tablespaces and combine drives into a single LVM VG and do something like
lvcreate --stripes
> I am not sure my autovacuum setup is working right though. I wonder if there
> isn't some autovacuum statistics which I can query that would give me
> confidence that it is actually running?
pg_stat_all_tables
Did you do this ?
ALTER TABLE ... SET (autovacuum_vacuum_scale_factor=0.001, autovacuum_vacuum_threshold=1);
Justin
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: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, raj@gusw.net
Subject: Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
In-Reply-To: <20190314155456.GG6030@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox