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

Le 17/07/2018 à 15:50, Robert Zenz a écrit :
> 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?

I was pretty sure it was, but looking at the litterature, it's not that 
obvious. Especially 
https://blog.pgaddict.com/posts/postgresql-performance-on-ext4-and-xfs 
seems to mentions that it doesn't change a thing, while others stress 
out that it is mandatory ( https://www.alibabacloud.com/forum/read-415, 
https://www.thomas-krenn.com/en/wiki/Partition_Alignment )
Even on mecanical drives it's been reported to cause slowdown ( 
https://www.ibm.com/developerworks/library/l-linux-on-4kb-sector-disks/index.html 
)

Maybe the OS are more clever now, making it not so important as before ?

Nicolas