Re: Make recently inserted/updated records available in the buffer/cache

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
To: Hüseyin Demir <demirhuseyinn(dot)94(at)gmail(dot)com>
Cc: Sachin Divekar <ssd532(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Make recently inserted/updated records available in the buffer/cache
Date: 2019-12-02 17:17:35
Message-ID: d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

All updated/dirty records go through PG internal memory buffer,
shared_buffers.  Make sure that is configured optimally.  Use
pg_buffercache extension to set it correctly.

Regards,
Michael Vitale

Hüseyin Demir wrote on 12/2/2019 12:13 PM:
> I guess there won't be any adverse effect

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Eugene Podshivalov 2019-12-02 19:03:51 Re: Considerable performance downgrade of v11 and 12 on Windows
Previous Message Hüseyin Demir 2019-12-02 17:13:09 Re: Make recently inserted/updated records available in the buffer/cache