[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: postgresql-performance using sysbench
- To: "Niki Denev" <nike_d_(_at_)_cytexbg_(_dot_)_com>
- Subject: Re: postgresql-performance using sysbench
- From: "Claus Guttesen" <kometen_(_at_)_gmail_(_dot_)_com>
- Date: Fri, 1 Feb 2008 09:24:15 +0100
- Cc: freebsd-performance_(_at_)_freebsd_(_dot_)_org
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=dTdsI3lfeoCKIKNNM3ghUpEK5biONX2Ipu2WRGqKf4s=; b=oZdQWFghT4OO2iVudFzC3Ftmy0RUQJebQuNeveikIEKHt796SXUNrl2Q+8GegnPHvIGfCWAQcYQkjbig/OoO6RmQOwuBIiSaBlwgPCQQhZHx2QhsSFdYx9Ivv6PdxETHU7LLL1MzL9ijGbF+/2kHTAAaOz1XUsd7yw1ZqxnChVk=
> Just a thought on the effect that HZ has on filesystem (and overall)
> performance :
> Linux has sort of backtracked from defaulting to HZ=1000 and enable it
> only on kernels compiled
> for "Desktop" work, and setting HZ=250 for the "Server" profile.
I'm doing some db-imports on postgresql on a file which takes 3 hours
and 40 min. with default HZ (1000). Then I changed HZ to 250 (in
loader.conf) and rebooted. The import still took 3 h. 40 min. so
altering HZ does not seem to have any influence.
#>sysctl kern.clockrate
kern.clockrate: { hz = 250, tick = 4000, profhz = 166, stathz = 33 }
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.
Shakespeare
_______________________________________________
freebsd-performance_(_at_)_freebsd_(_dot_)_org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe_(_at_)_freebsd_(_dot_)_org"
Visit your host, monkey.org