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
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
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.
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
