Postgres Pro
Downloads
Home   >   mailing lists

Re: Sudden insert performance degradation - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Sudden insert performance degradation
Date
Msg-id CAHOFxGqMR1E469mQ+ADfB53eEkeUZ7b9j7wzCvKx0i5AOwf8_g@mail.gmail.com
Whole thread Raw
In response to Re: Sudden insert performance degradation  (Sebastian Dressler <sebastian@swarm64.com>)
Responses Re: Sudden insert performance degradation  (Henrique Montenegro <typoon@gmail.com>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Sebastian Dressler
Date:
Subject: Re: Sudden insert performance degradation
Next
From: Henrique Montenegro
Date:
Subject: Re: Sudden insert performance degradation