DaemonForums  

Go Back   DaemonForums > FreeBSD > FreeBSD Ports and Packages

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

Reply
 
Thread Tools Display Modes
  #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
  #2   (View Single Post)  
Old 15th November 2022
ivan_bsd ivan_bsd is offline
New User
 
Join Date: Nov 2022
Location: Saskatchewan
Posts: 1
Default

Are you expecting this machine to suddenly go under heavy load?
Reply With Quote
  #3   (View Single Post)  
Old 15th November 2022
jggimi's Avatar
jggimi jggimi is offline
More noise than signal
 
Join Date: May 2008
Location: USA
Posts: 8,020
Default

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.
Reply With Quote
Reply

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 06:55 PM.


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