On 17.07.2018 15:44, Nicolas Charles wrote:
> - Partitions is not correctly aligned on the SSD blocks
Does that really make a noticeable difference? If yes, have you got some further
reading material on that?
> Why did the HDD (7200 rpm) perform better?
Are these different systems? Have you ruled out that during the HDD test the
data was available in memory?
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-
> De : Robert Zenz [mailto:robert.z...@sibvisions.com]
> Envoyé : jeudi 11 janvier 2018 10:01
> À : pgsql-performa
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.