Re: Clear FS caches after postgresql stops

From: scott ribe <scott_ribe(at)elevated-dev(dot)com>
To: Jakub Jedelský <jakub(dot)jedelsky(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Clear FS caches after postgresql stops
Date: 2017-11-27 13:22:25
Message-ID: 3DF72595-3A7B-457E-A922-95860398F365@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Nov 27, 2017, at 4:16 AM, Jakub Jedelský <jakub(dot)jedelsky(at)gmail(dot)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's possible for changes to be skipped unless you use the -c flag.

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Runge, Steven 2017-11-27 16:19:19 RE: A particular database to move to other drive
Previous Message Jakub Jedelský 2017-11-27 11:16:49 Clear FS caches after postgresql stops