pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDoes Postgresql support 4KN/512e HDD/SSD?
3+ messages / 3 participants
[nested] [flat]
* Does Postgresql support 4KN/512e HDD/SSD?
@ 2022-10-05 00:46 yanliang lei <msdnchina@163.com>
2022-10-05 00:53 ` Re: Does Postgresql support 4KN/512e HDD/SSD? Scott Ribe <scott_ribe@elevated-dev.com>
2022-10-10 20:13 ` Re: Does Postgresql support 4KN/512e HDD/SSD? Rui DeSousa <rui@crazybean.net>
0 siblings, 2 replies; 3+ messages in thread
From: yanliang lei @ 2022-10-05 00:46 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Does Postgresql support 4KN/512e HDD/SSD?
2022-10-05 00:46 Does Postgresql support 4KN/512e HDD/SSD? yanliang lei <msdnchina@163.com>
@ 2022-10-05 00:53 ` Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Ribe @ 2022-10-05 00:53 UTC (permalink / raw)
To: yanliang lei <msdnchina@163.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
> 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 system you provide.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Does Postgresql support 4KN/512e HDD/SSD?
2022-10-05 00:46 Does Postgresql support 4KN/512e HDD/SSD? yanliang lei <msdnchina@163.com>
@ 2022-10-10 20:13 ` Rui DeSousa <rui@crazybean.net>
1 sibling, 0 replies; 3+ messages in thread
From: Rui DeSousa @ 2022-10-10 20:13 UTC (permalink / raw)
To: yanliang lei <msdnchina@163.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
> 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-10-10 20:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-05 00:46 Does Postgresql support 4KN/512e HDD/SSD? yanliang lei <msdnchina@163.com>
2022-10-05 00:53 ` Scott Ribe <scott_ribe@elevated-dev.com>
2022-10-10 20:13 ` Rui DeSousa <rui@crazybean.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox