Re: Why HDD performance is better than SSD in this case

2018-07-17 Thread Robert Zenz
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?

Re: Why HDD performance is better than SSD in this case

2018-07-17 Thread Robert Zenz
> 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?

Re: Slow queries after Windows startup

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

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.