From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Hüseyin Demir <demirhuseyinn.94@gmail.com>
Cc: Sachin Divekar <ssd532@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Make recently inserted/updated records available in the buffer/cache
Date: Mon, 2 Dec 2019 12:17:35 -0500
Message-ID: <d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com> (raw)
In-Reply-To: <CALqEK1cDD5BRXeUkmbLJdbohfE6O0QycYUfm0j3PS96LSojxtQ@mail.gmail.com>
References: <CA+A8H7mJiWaohQv0k6Fv2i-nuRKyzDKu-J8vwp_DS72=zL-eCw@mail.gmail.com>
<CALqEK1cDD5BRXeUkmbLJdbohfE6O0QycYUfm0j3PS96LSojxtQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: MichaelDBA@sqlexec.com, demirhuseyinn.94@gmail.com, ssd532@gmail.com
Subject: Re: Make recently inserted/updated records available in the buffer/cache
In-Reply-To: <d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox