Re: Sudden insert performance degradation

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Sebastian Dressler <sebastian(at)swarm64(dot)com>
Cc: Henrique Montenegro <typoon(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sudden insert performance degradation
Date: 2020-07-13 16:27:39
Message-ID: CAHOFxGqMR1E469mQ+ADfB53eEkeUZ7b9j7wzCvKx0i5AOwf8_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is this an insert only table and perhaps not being picked up by autovacuum?
If so, try a manual "vacuum analyze" before/after each batch run perhaps.
You don't mention updates, but also have been adjusting fillfactor so I am
not not sure.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Henrique Montenegro 2020-07-13 16:42:37 Re: Sudden insert performance degradation
Previous Message Sebastian Dressler 2020-07-13 15:20:27 Re: Sudden insert performance degradation