Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1ibpKT-0000E9-UR
	for pgsql-performance@arkaria.postgresql.org; Mon, 02 Dec 2019 17:17:46 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1ibpKS-00068x-Mv
	for pgsql-performance@arkaria.postgresql.org; Mon, 02 Dec 2019 17:17:44 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1ibpKS-00061t-7g
	for pgsql-performance@lists.postgresql.org; Mon, 02 Dec 2019 17:17:44 +0000
Received: from mout.perfora.net ([74.208.4.197])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1ibpKP-0004pw-3m
	for pgsql-performance@postgresql.org; Mon, 02 Dec 2019 17:17:43 +0000
Received: from [192.168.1.101] ([98.169.208.73]) by mrelay.perfora.net
 (mreueus004 [74.208.5.2]) with ESMTPSA (Nemesis) id 1MfYkG-1i9OOX1SsS-00g1w3;
 Mon, 02 Dec 2019 18:17:37 +0100
Subject: Re: Make recently inserted/updated records available in the
 buffer/cache
To: =?UTF-8?Q?H=c3=bcseyin_Demir?= <demirhuseyinn.94@gmail.com>
Cc: Sachin Divekar <ssd532@gmail.com>, pgsql-performance@postgresql.org
References: 
 <CA+A8H7mJiWaohQv0k6Fv2i-nuRKyzDKu-J8vwp_DS72=zL-eCw@mail.gmail.com>
 <CALqEK1cDD5BRXeUkmbLJdbohfE6O0QycYUfm0j3PS96LSojxtQ@mail.gmail.com>
From: MichaelDBA <MichaelDBA@sqlexec.com>
Message-ID: <d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com>
Date: Mon, 2 Dec 2019 12:17:35 -0500
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 PostboxApp/7.0.8
MIME-Version: 1.0
In-Reply-To: 
 <CALqEK1cDD5BRXeUkmbLJdbohfE6O0QycYUfm0j3PS96LSojxtQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
X-Provags-ID: V03:K1:2Us4S7aJPHyvyT0emWcidlWNgTeiagkd8drkOq1xSDhIrOPaDOb
 Y4hEbiaqhNcjzXQL7gqAB8fvhh8jLiEnDggwm9I52mz56ISVEaZum1VRecmxGOq1eqA8OwQ
 bmuWG0f0mJsWkM7fVOcy81hRpK25BOUi5ybIpVMMjkJMFfqn5nufc+XinLdMglT5S4KbLj6
 7cO7o7L5+S6HKpnZt/J4w==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:eIbCCy/w2fw=:hnBAZSDPu7+Qu+kwmQcloc
 1iu86xSaVrQIPXkZDF2nKuA1nGypth4qpfu5uwkETE7g1vVZ7dorsQPIaWkxkjU7jnBtj9u0C
 KnyuGr2zfeEpjnnBP+Ryij0h/WEq97aQSDgd5XurqBc3sBry82o+IYwlR20ldVpmJwjhIPyYP
 8XMvMwhDWCj6KJctqgswUtg7M+7qHipwGKyE8/JipmLn+uNKkwniq1UswlTjqsAAK6LlP59wG
 6Gbyi2l7f6COxEntHsGZ2Zj7N4sdmdELPqQcEovmVLtIpMeDAY9kkcRbfVH56kIFa7yHjw0Nh
 wikfluO2QLyZUMAgsgHoCXb5kcs0Q7YFaiHXxzzWJZrotGp4gtiiK8cwqM7GDrujO1whe/HYD
 uxecCZPDi8RtleSF2sbAdMiBAoHbTD7B29HNh4JQxG22S1sOAKZZXuHoDwenKMEIhu0K1PdoK
 5SExDEjmqMCNd+/Iqejvdv5GaCXt4yfDuT4/uyoSfv3U2uST6wsps3NVIebbWvXAI7taZ5ucI
 Sa/1E0FBcSb5ictntfZ4CYzlHFA/TzpMI+Cd3Cuw922ILZkjKdV5FfcpyA/6lUW8j3pmcpOaP
 Gxw+ihhEoAn37Vu8hcGoBIF0HBRFCSvqp3zTTvyH6fczKbX+pMXgLLKdf3KFKtPamrRa1paUr
 6RQwsO+Mf4QYndRkUMAe1+LtK+ipxZLAW+rkEqdFoqJ7ehzOrOM8Lpg9GwLs3+AuW/CnLvo2X
 YC5pCVNC45ZEaRIGsENBJs4OKYMbCa1xm9cy5jFXKh/J+ZBNvhHnqn5ljR5f/VNtR7L2gcIew
 /oj/RrGvXznzHWmzxw6yty4PhdYCVCLZWj9gRsy7Xszroxadf92L0iG6WkhFkCapwY1lWgsnq
 9iwJQNyt3adONHtr4xjGJUglHOruz40cQtKSsZ1Xw=
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

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