View Single Post
  #1   (View Single Post)  
Old 28th October 2017
hanzer's Avatar
hanzer hanzer is offline
Real Name: Adam Jensen
just passing through
 
Join Date: Oct 2013
Location: EST USA
Posts: 314
Default PostgreSQL on ZFS

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):
Code:
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?
Reply With Quote