Re: Does Postgresql support 4KN/512e HDD/SSD?

From: Rui DeSousa <rui(at)crazybean(dot)net>
To: yanliang lei <msdnchina(at)163(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Does Postgresql support 4KN/512e HDD/SSD?
Date: 2022-10-10 20:13:25
Message-ID: 56A2AAC6-14B1-46E2-B0D3-DDA4FF0063BC@crazybean.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Oct 4, 2022, at 8:46 PM, yanliang lei <msdnchina(at)163(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nikhil Ingale 2022-10-12 10:59:08 Pg backup
Previous Message Pepe TD Vo 2022-10-08 13:23:45 Re: Database Corrupted. Please contact the vendor Error: Reg