Re: What does \timing measure?

Поиск
Список
Период
Сортировка
Искать
От
Josh Kupershmidt
Тема
Re: What does \timing measure?
Дата
Msg-id
BANLkTi=LBrmB14jd7fwiKKAti8Va89fgLA@mail.gmail.com
Ответ на
Re: What does \timing measure? (Mathieu Dubois)
Список
Дерево обсуждения
What does \timing measure? Mathieu Dubois <mathieu.dubois@limsi.fr>
Re: What does \timing measure? Josh Kupershmidt <schmiddy@gmail.com>
Re: What does \timing measure? Mathieu Dubois <mathieu.dubois@limsi.fr>
Re: What does \timing measure? Josh Kupershmidt <schmiddy@gmail.com>
Re: What does \timing measure? Mathieu Dubois <mathieu.dubois@limsi.fr> 
On Fri, Apr 8, 2011 at 2:31 AM, Mathieu Dubois  wrote:
> Yes I'm really interested in the "cold query time".
> Is restarting PostgreSQL mandatory? What about just log out (from
> PostgreSQL), wait some time (let's say 1mn) and then relog?

Logging out from Postgres isn't going to do anything to clear its
buffercache. AFAIK the only way to wipe it is to shutdown the server
and start it back up.

> Also a quick googling shows that to clear OS cache I can run (on the
> server):
>
> sync;
> sysctrl -w vm.drop_caches=3;
>
> Is that right?

I believe that's right, if you're on Linux with a recent kernel.

Josh
В списке pgsql-novice по дате отправления
Предыдущее
От: Mathieu Dubois
Дата:
Сообщение: Re: What does \timing measure?
Следующее
От: Grzegorz Szpetkowski
Дата:
FAQ