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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Make recently inserted/updated records available in the buffer/cache
From: MichaelDBA <MichaelDBA@xxxxxxxxxxx>
Date: Mon, 2 Dec 2019 12:17:35 -0500
Cc: Sachin Divekar <ssd532@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <CALqEK1cDD5BRXeUkmbLJdbohfE6O0QycYUfm0j3PS96LSojxtQ@mail.gmail.com>
References: <CA+A8H7mJiWaohQv0k6Fv2i-nuRKyzDKu-J8vwp_DS72=zL-eCw@mail.gmail.com> <CALqEK1cDD5BRXeUkmbLJdbohfE6O0QycYUfm0j3PS96LSojxtQ@mail.gmail.com>
User-agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.8

All updated/dirty records go through PG internal memory buffer,shared_buffers. Make sure that is configured optimally. Usepg_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

Follow-Ups:
- Re: Make recently inserted/updated records available in the buffer/cache
  - From: Michael Lewis

References:
- Make recently inserted/updated records available in the buffer/cache
  - From: Sachin Divekar
- Re: Make recently inserted/updated records available in the buffer/cache
  - From: Hüseyin Demir

Prev by Date: Re: Make recently inserted/updated records available in the buffer/cache
Next by Date: Re: Considerable performance downgrade of v11 and 12 on Windows
Previous by thread: Re: Make recently inserted/updated records available in the buffer/cache
Next by thread: Re: Make recently inserted/updated records available in the buffer/cache
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux