Re: Sudden insert performance degradation
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Sudden insert performance degradation
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Mon, 13 Jul 2020 10:27:39 -0600
Cc
: Henrique Montenegro <typoon@xxxxxxxxx>, "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to
: <
60FCBB38-EF23-4917-BDDB-486D9FC98135@swarm64.com
>
References
: <
CAH_aqbuP_KBDM7b4RmR0MEDFQz+yukc9i1WFwf_rcAwznEa6bg@mail.gmail.com
> <
60FCBB38-EF23-4917-BDDB-486D9FC98135@swarm64.com
>
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.
Follow-Ups
:
Re: Sudden insert performance degradation
From:
Henrique Montenegro
References
:
Sudden insert performance degradation
From:
Henrique Montenegro
Re: Sudden insert performance degradation
From:
Sebastian Dressler
Prev by Date:
Re: Sudden insert performance degradation
Next by Date:
Re: Sudden insert performance degradation
Previous by thread:
Re: Sudden insert performance degradation
Next by thread:
Re: Sudden insert performance degradation
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
