From: Thomas Markus <t.markus@proventis.net>
To: pgsql-admin@postgresql.org
Subject: Re: Autovacuum after bulk data insert(millions!)
Date: Tue, 17 Oct 2017 13:48:21 +0200
Message-ID: <f8698162-8ca7-0cf8-8738-d44726223af7@proventis.net> (raw)
In-Reply-To: <CAAV2-mX6k2G-v95b-0tK5BjF14TkQ2mGBpdx5FAgTxKkhsGAvQ@mail.gmail.com>
References: <CAAV2-mXmqCYn3Q56rpk65cXABFv8TqX7fVPoN_BQhNnynL38YQ@mail.gmail.com>
<CAPfkCSAtzO1oLnAC8zGN7vTGDNe6sgEpQLtj6npbDqGSa-8gfQ@mail.gmail.com>
<CAAV2-mX6k2G-v95b-0tK5BjF14TkQ2mGBpdx5FAgTxKkhsGAvQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
Am 17.10.17 um 13:37 schrieb Günce Kaya:
> Hello Fabrízio,
>
> Thank you for your advice but I'm not asking for only a specific table
> and not looking for temporary solution. Previous post may not clear to
> much and I'd explain again.
>
> So autovacuum process takes long time for that database. I don't know
> how can I estimate timing for a vacuum after insert millions of bulk
> data to a table. So there are many table inserting bulk data daily.
> This solution not for only a table. I'm looking a solution for a
> database. Data volume of this database is around 2GB so many
> transactions in a day.
>
> This is only suggestion and I'm really curious because can not
> estimate what do you think about that, what if disable autovacuum and
> vacuum all tables in every month?
>
> Regards,
> Gunce
works same for a database, so it depends on your usecase
* disable autovacuum for instance
* run 'vacuumdb -a -z' manually/in cron
Regards
Thomas
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-admin@postgresql.org
Cc: t.markus@proventis.net
Subject: Re: Autovacuum after bulk data insert(millions!)
In-Reply-To: <f8698162-8ca7-0cf8-8738-d44726223af7@proventis.net>
* 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