Running PostgreSQL on Compression-enabled ZFS

Re:Running PostgreSQL on Compression-enabled ZFS by atoponce on Monday April 22, 2013 @03:48PM (#5591393)

I'm curious of the rest of the architecture. Each benchmark needs to be tested separately, as ZFS is likely caching the reads in the ARC. We also need a benchmark of ZFS without compression enabled.

However, we're not showing how bad ext3 is, but that the end result still shows the stellar performance, compression or not.

[ Parent | on HN ]

Re:Running PostgreSQL on Compression-enabled ZFS by cwsteinbach on Monday April 22, 2013 @05:27PM (#5591866)

> as ZFS is likely caching the reads in the ARC

Each of the seven queries we used in our benchmark required a sequential scan of the 32GB dataset. It's unlikely that the ARC had any impact on the results since the EC2 instance had only 7GiB of memory.

[ Parent | on HN ]

Re:Running PostgreSQL on Compression-enabled ZFS by GalacticDomin8r on Monday April 22, 2013 @04:54PM (#5591712)

ext3 does suck for certain workloads, one of them being large scale db's. And by suck, I mean dangerous. Unless you really want to set barrier on the fs and watch your IO plummet to 45 record player speeds.

[ Parent | on HN ]

Re:Running PostgreSQL on Compression-enabled ZFS by iso8859-1 on Monday April 22, 2013 @05:34PM (#5591909)

What is the reason for using ext3 over ext4?

[ Parent | on HN ]