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
Date: 2019-12-03 17:29:18
Message-ID: CAHOFxGozXOq=6Q1UOWi5=L1bvNvke_Rn+U-nm6FruxM-F61tSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"I am going to use it as a queue"

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message MichaelDBA 2019-12-03 17:32:48 Re: Make recently inserted/updated records available in the buffer/cache
Previous Message Aufar Gilbran 2019-12-03 07:50:43 Re: [External] Join queries slow with predicate, limit, and ordering