You should check this blog:
http://blog.coelho.net/database/2013/08/14/postgresql-warmup.html
To warm-up your DB after reboot.
Let me know
Regards
Eric
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
é : jeudi 11 janvier 2018 10:55
À : pgsql-performance@lists.postgresql.org
Objet : Re: Slow queries after Windows startup
I have no idea to be honest, I haven't done any Windows administration in a
long time.
The best I could find is this:
* https://docs.microsoft.com/en-us/sysinternals/
nce@lists.postgresql.org
> Objet : Re: Slow queries after Windows startup
>
> Have you verified that this is isn't caused by cold filesystem caches?
>
>
> On 11.01.2018 09:19, POUSSEL, Guillaume wrote:
>> Hello,
>>
>>
>>
>> I’m running Postg
No, I have not checked it.
How can I monitor it on Windows? Do you know a tool that can help me?
Thanks!
-Message d'origine-
De : Robert Zenz [mailto:robert.z...@sibvisions.com]
Envoyé : jeudi 11 janvier 2018 10:01
À : pgsql-performance@lists.postgresql.org
Objet : Re: Slow qu
Have you verified that this is isn't caused by cold filesystem caches?
On 11.01.2018 09:19, POUSSEL, Guillaume wrote:
> Hello,
>
>
>
> I’m running PostgreSQL 9.3 on Windows 7 and I’m having a performance
> issue at startup. I have installed PostgreSQL as a service through Windows
> installer.