On 4/17/19 6:38 PM, Gunther Schadow wrote:
> So looks like XFS won. I like XFS for its ease of use especially when
> growing.
>
> Any ideas on how ZFS might do? ZFS is of course so much more flexible.
That would totally depend on your data sets and expectations. If you're
doing a LOT of random i
On Thu, Apr 18, 2019 at 02:19:28AM +, Stephan Schmidt wrote:
my Question was meant for a Debian 9 environment with heavy read/wright
load and very high requirements towards Performance and data Consistency
Well, that's like asking "which car is the best" unfortunately. There's no
good answ
-performance@lists.postgresql.org
Betreff: Re: Best Filesystem for PostgreSQL
On Wed, Apr 17, 2019 at 08:59:13PM +, Stephan Schmidt wrote:
> What would be the best filesystem to run PostgreSQL on, in Terms of
> Performance
> and data Integrity?
Uh, which operating system? If it is Linux, ma
On 4/17/2019 18:03, Imre Samu wrote:
test: PostgreSQL v10.3 + Linux 5.0 File-System Benchmarks: Btrfs
vs. EXT4 vs. F2FS vs. XFS
https://www.phoronix.com/scan.php?page=article&item=linux-50-filesystems&num=3
So looks like XFS won. I like XFS for its ease of use especially when
growing.
Any
> best filesystem to run PostgreSQL on, in Terms of Performance ...
test:PostgreSQL v10.3 + Linux 5.0 File-System Benchmarks: Btrfs vs.
EXT4 vs. F2FS vs. XFS
https://www.phoronix.com/scan.php?page=article&item=linux-50-filesystems&num=3
Imre
Stephan Schmidt ezt írta (időpont: 2019. ápr. 1
On Wed, Apr 17, 2019 at 08:59:13PM +, Stephan Schmidt wrote:
> What would be the best filesystem to run PostgreSQL on, in Terms of
> Performance
> and data Integrity?
Uh, which operating system? If it is Linux, many people like ext4 or
xfs. Some like zfs. ext3/ext2 are not recommended due
What would be the best filesystem to run PostgreSQL on, in Terms of Performance
and data Integrity?
Best regards,
stephan
