Re: Clear FS caches after postgresql stops

Поиск
Список
Период
Сортировка
От scott ribe
Тема Re: Clear FS caches after postgresql stops
Дата
Msg-id 3DF72595-3A7B-457E-A922-95860398F365@elevated-dev.com
обсуждение исходный текст
Ответ на Clear FS caches after postgresql stops  (Jakub Jedelský <jakub.jedelsky@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jakub Jedelský
Дата:
Сообщение: Clear FS caches after postgresql stops
Следующее
От: "Runge, Steven"
Дата:
Сообщение: RE: A particular database to move to other drive