Re: Clear FS caches after postgresql stops - Mailing list pgsql-admin

From scott ribe
Subject Re: Clear FS caches after postgresql stops
Date
Msg-id 3DF72595-3A7B-457E-A922-95860398F365@elevated-dev.com
Whole thread Raw
In response to Clear FS caches after postgresql stops  (Jakub Jedelský <jakub.jedelsky@gmail.com>)
List pgsql-admin
On Nov 27, 2017, at 4:16 AM, Jakub Jedelský <jakub.jedelsky@gmail.com> wrote:
>
> Is it possible, that Postgresql leave some data in memory after its stop?

Not unless you turned fsynch off in the conf, and you really should NOT be doing that for production.

Remember that rsync normally compares timestamp & size, and that timestamps are often only 1-second precision. Thus
it'spossible for changes to be skipped unless you use the -c flag. 

--
Scott Ribe
https://www.linkedin.com/in/scottribe/
(303) 722-0567



pgsql-admin by date:

Previous
From: Jakub Jedelský
Date:
Subject: Clear FS caches after postgresql stops
Next
From: "Runge, Steven"
Date:
Subject: RE: A particular database to move to other drive