RE: Slow queries after Windows startup

2018-01-12 Thread Éric Fontaine
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

RE: Slow queries after Windows startup

2018-01-11 Thread POUSSEL, Guillaume
é : 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/

Re: Slow queries after Windows startup

2018-01-11 Thread Robert Zenz
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

RE: Slow queries after Windows startup

2018-01-11 Thread POUSSEL, Guillaume
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

Re: Slow queries after Windows startup

2018-01-11 Thread Robert Zenz
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.