PostgreSQL on ZFS

[hanzer]

Hi,

I am running PostgreSQL-9.5 on a FreeBSD-11.1 machine and the filesystem is a two-disk ZFS mirror. This is a little box under light load (but it has important data on it):

CPU: Intel(R) Celeron(R) CPU  J1900  @ 1.99GHz (2000.05-MHz K8-class CPU)
real memory  = 8589934592 (8192 MB)

I am curious about what might happen if the database operates under heavy load. Will throughput top off and response time slow down but the overall system continues to function, or might the system undergo some kind of thrash and crash failure scenario?

Does anyone here have experience with a similar configuration that has been pushed into resource exhaustion? Any tuning advice that will keep the system stable, even under very heavy load?

[ivan_bsd]

Are you expecting this machine to suddenly go under heavy load?

[jggimi]

Hello and welcome!

FYI: You probably didn't notice that you're responding to a 5-year-old post, and its author hasn't visited this forum in 3 years.