Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hWhgo-0007RP-BO for pgsql-admin@arkaria.postgresql.org; Fri, 31 May 2019 13:35:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hWhgm-0007PS-Ls for pgsql-admin@arkaria.postgresql.org; Fri, 31 May 2019 13:35:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hWhgm-0007PL-A1 for pgsql-admin@lists.postgresql.org; Fri, 31 May 2019 13:35:20 +0000 Received: from w1.tutanota.de ([81.3.6.162]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hWhgj-0006XY-0T for pgsql-admin@lists.postgresql.org; Fri, 31 May 2019 13:35:19 +0000 Received: from w2.tutanota.de (unknown [192.168.1.163]) by w1.tutanota.de (Postfix) with ESMTP id 9D1A1FBF499; Fri, 31 May 2019 13:35:14 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=tuta.io; s=20161216; t=1559309714; bh=Aq3Bbtu6qheSSTecBUzO43r4y52pWE2UyZVAIvKbrHk=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From; b=hhaA/CqmdPTCvBdqDipKsNjvMVP/YaJZakTyHRBJO4PsoNm0e+BN+6tNhRByQ3y00 v2n0fDC/JQJJN/SfnHxTYCeXA1NPdMXaRHtf8FMHCnVby/HkvcZ2hgfIVz6aZg2sY8 VUHA2WBtKaUJ0vQbaChQmPsRdQcHTxwAO2ek6GXFEZVKVdH0UNxqItz5zfWr/tQbMU O9uSE+BhLG/4Tqkx/H95A+24bUB37P6JUkWf9o/Pg9nMgZTFqyOPglVigZTGgh/N5x GzAhPQtLpuY8H1ud1ENqiCP0iuery4dup5aNTMqRod6bhIPDIQMk+gzHX0zQcryTjM Z8SGif7kqO93Q== Date: Fri, 31 May 2019 15:35:14 +0200 (CEST) From: To: Achilleas Mantzios Cc: Message-ID: In-Reply-To: <4faf4818-1249-3f0c-e105-b649bab24b45@matrix.gatewaynet.com> References: <4faf4818-1249-3f0c-e105-b649bab24b45@matrix.gatewaynet.com> Subject: Re: 8Kb or 4Kb ext4 filesystem page size MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_60_346746120.1559309714635" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_60_346746120.1559309714635 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, Great article!=C2=A0 "FS is becoming less and less relevant", agreed.=C2=A0= For the days of raw... What about when it comes to postgres file system design?=C2=A0 By this I me= an I've been challenged to find a good resource addressing postgres file sy= stem best practice regardless of EXT4, XFS, etc..=C2=A0 For example, partit= ion order on drive, reordering, tuning and more.=C2=A0 Question is obviousl= y dependent upon OS' available file systems, just thought I'd ask what othe= rs are coming across.=C2=A0=20 Thanks --=20 Securely sent with Tutanota. Get your own encrypted, ad-free mailbox:=20 https://tutanota.com May 30, 2019, 1:12 AM by achill@matrix.gatewaynet.com: > On 29/5/19 9:10 =CE=BC.=CE=BC., Alexandre hadjinlian guerra wrote: > >> Hi >> >> Given that postgres uses 8Kb pages, im wondering why i couldnt see any t= ests 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 make= s 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 pgs= ql fs, just hasn't been the case with us. > Having said that, in the era of could based or vm-based postgresql instal= lation, the question of choice of FS is becoming less and less relevant. Ju= st make sure to secure your data, and that you don't over tune your fs at t= he expense of data safety. > >> >> Thanks >> > > > --=20 > Achilleas Mantzios > IT DEV Lead > IT DEPT > Dynacom Tankers Mgmt > ------=_Part_60_346746120.1559309714635 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,
Great article!  "FS is becoming less and less rel= evant", agreed.  For the days of raw...

What a= bout when it comes to postgres file system design?  By this I mean I'v= e been challenged to find a good resource addressing postgres file system b= est practice regardless of EXT4, XFS, etc..  For example, partition or= der on drive, reordering, tuning and more.  Question is obviously depe= ndent upon OS' available file systems, just thought I'd ask what others are= coming across. 
Thanks

--
Securely sent wi= th 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 =CE=BC.=CE= =BC., Alexandre hadjinlian guerra wrote:
Hi

Given that postgres u= ses 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 know= ledge about such lack of tests on the internet makes me wonder if im lookin= g poorly or just lack of testing. besides, i do ask if the following link r= emain true given XFS and EXT4 evolution since 2015
https://blog.pgaddict.com/posts/postgresql-perform= ance-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-b= ased 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

------=_Part_60_346746120.1559309714635--