Postgres Pro
Downloads
Home   >   mailing lists

Re: Make recently inserted/updated records available in thebuffer/cache - Mailing list pgsql-performance

From MichaelDBA
Subject Re: Make recently inserted/updated records available in thebuffer/cache
Date
Msg-id d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com
Whole thread Raw
In response to Re: Make recently inserted/updated records available in the buffer/cache  (Hüseyin Demir <demirhuseyinn.94@gmail.com>)
Responses Re: Make recently inserted/updated records available in the buffer/cache  (Michael Lewis <mlewis@entrata.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Hüseyin Demir
Date:
Subject: Re: Make recently inserted/updated records available in the buffer/cache
Next
From: Eugene Podshivalov
Date:
Subject: Re: Considerable performance downgrade of v11 and 12 on Windows