Hello Michael,
On 22/06/2021 14.00, MichaelDBA wrote:
I'm wondering if bloat could be causing a problem. Perhaps more
blocks are written to disk including a lot of blocks with little or no
data due to bloat.
Using the query suggested here:
www.citusdata.com/blog/2017/10/20/monitoring-your-bloat-in-postgres/, I
get the following:
databasename | db1
schemaname | schema1
tablename | t1
can_estimate | t
est_rows | 160
pct_bloat | 18
mb_bloat | 0.06
table_mb | 0.352
So the bloat doesn't seem significant.
Best regards
Dimitre
