RE: Query is slow when run for first time; subsequent execution is fast

2018-01-16 Thread POUSSEL, Guillaume
Hello, FWIW, I do have the same issue. Unfortunately our application is running on a standard laptop/desktop computers, not dedicated servers. Restarting the computer leads to a restart of the database server, which slow down all queries for several minutes. Are you on Windows or Linux?

RE: Slow queries after Windows startup

2018-01-11 Thread POUSSEL, Guillaume
downloads/rammap * https://technet.microsoft.com/en-us/library/cc938589.aspx On 11.01.2018 10:06, POUSSEL, Guillaume wrote: > 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- >

RE: Slow queries after Windows startup

2018-01-11 Thread POUSSEL, Guillaume
eries 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 PostgreSQL 9.3 on Windows 7 and I’m having a performance > issue at startup. I have installed Pos

Slow queries after Windows startup

2018-01-11 Thread POUSSEL, Guillaume
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. The database size is 3 Go, with 120 tables. Every time I try to run queries right after Windows startup, it takes a huge amount