Thread: Does Postgresql support 4KN/512e HDD/SSD?
in the disk industry, hdd has 4kn and 512e, ssd has 4kn and 512e.
I want to know about postgresql database supports 4kn/512e in the hdd/ssd or not.
thanks a lot!
> On Oct 4, 2022, at 6:46 PM, yanliang lei <msdnchina@163.com> wrote: > > in the disk industry, hdd has 4kn and 512e, ssd has 4kn and 512e. > I want to know about postgresql database supports 4kn/512e in the hdd/ssd or not. > > thanks a lot! Completely irrelevant to Postgres, as it does not attempt to use raw devices. It uses normal files, on whatever file systemyou provide.
On Oct 4, 2022, at 8:46 PM, yanliang lei <msdnchina@163.com> wrote:in the disk industry, hdd has 4kn and 512e, ssd has 4kn and 512e.I want to know about postgresql database supports 4kn/512e in the hdd/ssd or not.
You want to make sure your filesystem is aligned correctly; otherwise that will impact performance.