Re: Make recently inserted/updated records available in the buffer/cache
From:
Michael Lewis <mlewis(at)entrata(dot)com>
To:
MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
Cc:
Hüseyin Demir <demirhuseyinn(dot)94(at)gmail(dot)com>, Sachin Divekar <ssd532(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject:
Re: Make recently inserted/updated records available in the buffer/cache
You may want to look at lowering fillfactor if this queue is going to have frequent updates, and also make autovacuum/analyze much more aggressive assuming many updates and deletes.