From: tutaver@tuta.io
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: 8Kb or 4Kb ext4 filesystem page size
Date: Fri, 31 May 2019 15:35:14 +0200 (CEST)
Message-ID: <LgD5U8y--3-1@tuta.io> (raw)
In-Reply-To: <4faf4818-1249-3f0c-e105-b649bab24b45@matrix.gatewaynet.com>
References: <CAOEJH=DaKncHO9tCeRq1v_K1H9pEgNdxdMfKhLYNk5zwdSOKLA@mail.gmail.com>
<4faf4818-1249-3f0c-e105-b649bab24b45@matrix.gatewaynet.com>
Hello,
Great article! "FS is becoming less and less relevant", agreed. For the days of raw...
What about when it comes to postgres file system design? By this I mean I've been challenged to find a good resource addressing postgres file system best practice regardless of EXT4, XFS, etc.. For example, partition order on drive, reordering, tuning and more. Question is obviously dependent upon OS' available file systems, just thought I'd ask what others are coming across.
Thanks
--
Securely sent with Tutanota. Get your own encrypted, ad-free mailbox:
https://tutanota.com
May 30, 2019, 1:12 AM by achill@matrix.gatewaynet.com:
> On 29/5/19 9:10 μ.μ., Alexandre hadjinlian guerra wrote:
>
>> Hi
>>
>> Given that postgres uses 8Kb pages, im wondering why i couldnt see any tests at all which would format ext4 partition to 8Kb pages. Im about to do some tests, but any knowledge about such lack of tests on the internet makes me wonder if im looking poorly or just lack of testing. besides, i do ask if the following link remain true given XFS and EXT4 evolution since 2015
>> https://blog.pgaddict.com/posts/postgresql-performance-on-ext4-and-xfs
>>
> This is just my personal opinion, and might be the case only with us, but anytime I had severe problems with any of our postgresql clusters this was with XFS. I know that XFS has been highly praised and recommended as a pgsql fs, just hasn't been the case with us.
> Having said that, in the era of could based or vm-based postgresql installation, the question of choice of FS is becoming less and less relevant. Just make sure to secure your data, and that you don't over tune your fs at the expense of data safety.
>
>>
>> Thanks
>>
>
>
> --
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tutaver@tuta.io, achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: 8Kb or 4Kb ext4 filesystem page size
In-Reply-To: <LgD5U8y--3-1@tuta.io>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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