DaemonForums  

Go Back   DaemonForums > FreeBSD > FreeBSD Ports and Packages

FreeBSD Ports and Packages Installation and upgrading of ports and packages on FreeBSD.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   (View Single Post)  
Old 3 Weeks Ago
hanzer's Avatar
hanzer hanzer is offline
Real Name: Adam Jensen
just passing through
 
Join Date: Oct 2013
Location: EST USA
Posts: 267
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
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Other PostgreSQL 9.5 released J65nko News 1 7th January 2016 09:10 PM
postgresql VS mysql .. when which is better ? daemonfowl General software and network 3 12th September 2012 05:30 AM
Hipsters hacking on PostgreSQL J65nko News 0 31st August 2012 06:36 PM
Security PostgreSQL patches XML flaws J65nko News 0 17th August 2012 09:56 PM
PostgreSql rc.d script fridder FreeBSD Ports and Packages 1 1st July 2008 01:12 AM


All times are GMT. The time now is 04:51 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick