On Wed, Jun 27, 2018 at 3:19 AM, Laurenz Albe
wrote:
> Ilyeop Yi wrote:
> > Currently, I am working with a workload that is mostly insert and
> update, and its performance suffers from autovacuum.
>
Do you know what about the autovacuum causes the performance drop? Is it
the reading, the writin
Ilyeop Yi wrote:
> Currently, I am working with a workload that is mostly insert and update, and
> its performance suffers from autovacuum.
>
> I've adjusted parameters such as vacuum_cost_delay and vacuum_cost_limit, but
> they have no significant effect.
>
> So, I would like to find a way to
Ilyeop Yi wrote:
> I have some questions about "cost-based vacuum delay".
>
> Q1. How can I know/check if the autovacuum is actually paused periodically
> according to autovacuum_vacuum_cost_limit and autovacuum_vacuum_cost_delay?
>
> I cannot find such an inform
0:29, Ilyeop Yi wrote:
>
> Hi Guys,
>
> I have some questions about "cost-based vacuum delay".
>
> Q1. How can I know/check if the autovacuum is actually paused periodically
> according to autovacuum_vacuum_cost_limit and autovacuum_vacuum_cost_delay?
>
>
Hi Guys,
I have some questions about "cost-based vacuum delay".
Q1. How can I know/check if the autovacuum is actually paused periodically
according to autovacuum_vacuum_cost_limit and autovacuum_vacuum_cost_delay?
I cannot find such an information from log files.
Q2. Is there