Re: Trying to go 8.1.24 to 9.3.2

On Thu, Mar 20, 2014 at 08:57:40AM +0900, Ian Lawrence Barwick wrote:
> 2014-03-20 7:32 GMT+09:00 The Doctor <doctor@doctor.nl2k.ab.ca>:
> > Help!
> >
> >
> > Everytime I run 8.1 my server average load mostly below 10.
> > Everytime I run 9.3 my server average load is about 30.
> >
> <snip>
> >
> >
> > Any clue to the runaway performance?
>
> What kind of environment is your installation running on (OS, memory etc.?)
>
> In particular your memory settings seem to be on the low side:
>
>   shared_buffers = 1024
>   work_mem = 64
>   maintenance_work_mem = 1024
>   temp_buffers = 100
>
> Unqualified values default to units of 8kB; it's generally easier to
> qualify them
> explicitly:
>
>   shared_buffers = 8MB
>   work_mem = 512kB
>   maintenance_work_mem = 8MB
>   temp_buffers = 800kB
>
> You very probably will be able to improve performance by increasing some or all
> of these values, but it's hard to say by how much without knowing more about
> your environment.
>
> Also I see that in your 8.1 configuration, "max_connections" is 20,
> but in 9.1 it's 5.
>


My sysctl -a


kern.ostype = BSD/OS
kern.osrelease = 4.3.1
kern.osrevision = 200105
kern.version = BSDI BSD/OS 4.3.1 Kernel #1: Fri Feb 21 06:45:47 MST 2014
    root@doctor.nl2k.ab.ca:/usr/src/sys/compile/LOCALb1i

kern.desiredvnodes = 35038
kern.maxproc = 16404
kern.maxfiles = 52364
kern.argmax = 262144
kern.securelevel = 1
kern.hostname = doctor.nl2k.ab.ca
kern.hostid = 4218497040
kern.clockrate: hz = 100, tick = 10000, profhz = 100, stathz = 100
kern.posix1version = 199009
kern.ngroups = 16
kern.job_control = 1
kern.saved_ids = 0
kern.boottime = Tue Mar 18 15:43:06 2014
kern.deadmantimer = 0
kern.maxsymlinks = 20
kern.nisdomainname =
kern.license: fc+j =VEa +L7m
kern.license_users = 64
kern.license_flags = 0
kern.numvnodes = 35038
kern.coresfollowlinks = 0
kern.autonicetime = 600
kern.use_cycle_time = 1
kern.cycles_per_second = 3200113746
kern.cycle_auto_adjust = 1
kern.vforksharemem = 0
kern.userpriority = 77
kern.rtmaxpriority = 84
vm.loadavg: 12.05 15.59 19.70
vm.swapreserve = 2048
vm.maxdsize = 1073741824
vm.maxssize = 67108864
vm.maxmapentries = 1024
vfs.generic.syncdelay = 30
vfs.generic.maxsyncdelay = 60
vfs.ufs has 4 mounted instances
vfs.nfs has 0 mounted instances
vfs.mfs has 1 mounted instance
vfs.msdos has 0 mounted instances
vfs.cd9660 has 0 mounted instances
net.socket.maxconn = 1024
net.socket.sbmax = 262144
net.socket.nmbclusters = 65536
net.inet.ip.forwarding = 1
net.inet.ip.redirect = 1
net.inet.ip.ttl = 64
net.inet.ip.forwsrcrt = 1
net.inet.ip.maxfragpackets = 200
net.inet.ip.sourcecheck = 1
net.inet.ip.sourcecheck_logint = 5
net.inet.ip.do_rfc1858 = 1
net.inet.icmp.maskrepl = 1
net.inet.icmp.rediraccept = 1
net.inet.icmp.redirtimeout = 600
net.inet.icmp.bmcastecho = 1
net.inet.tcp.mssdflt = 536
net.inet.tcp.do_rfc1323 = 1
net.inet.tcp.keepidle = 7200
net.inet.tcp.keepinterval = 75
net.inet.tcp.keepcount = 8
net.inet.tcp.maxpersistidle = 7200
net.inet.tcp.sendspace = 8192
net.inet.tcp.recvspace = 8192
net.inet.tcp.conntimeo = 75
net.inet.tcp.pmtu = 1
net.inet.tcp.pmtu_expire = 600
net.inet.tcp.pmtu_probe = 120
net.inet.tcp.43maxseg = 0
net.inet.tcp.syn_cache_limit = 34895
net.inet.tcp.syn_bucket_limit = 105
net.inet.tcp.syn_cache_interval = 8
net.inet.tcp.ifp_maxseg = 0
net.inet.tcp.pmtu_valid_level = 3
net.inet.udp.checksum = 1
net.inet.udp.sendmax = 9224
net.inet.udp.recvspace = 42080
net.inet.ip6.forwarding = 0
net.inet.ip6.redirect = 1
net.inet.ip6.hlim = 64
net.inet.ip6.forwsrcrt = 0
net.inet.ip6.maxfragpackets = 200
net.inet.ip6.sourcecheck = 0
net.inet.ip6.sourcecheck_logint = 0
net.inet.ip6.accept_rtadv = 0
net.inet.ip6.keepfaith = 0
net.inet.ip6.log_interval = 5
net.inet.ip6.hdrnestlimit = 50
net.inet.ip6.dad_count = 1
net.inet.ip6.auto_flowlabel = 1
net.inet.ip6.defmcasthlim = 1
net.inet.ip6.gifhlim = 30
net.inet.ip6.kame_version = SNAP 20010326
net.inet.ip6.use_deprecated = 1
net.inet.ip6.rr_prune = 5
net.inet.ip6.v6only = 0
net.inet.ip6.use_tempaddr = 0
net.inet.ip6.temppltime = 86400
net.inet.ip6.tempvltime = 604800
net.inet.ip6.auto_linklocal = 1
net.route.idletimeout = 600
net.route.netclone = 1
net.route.arp.probe = 120
net.route.arp.maxtries = 5
net.route.arp.down = 20
net.route.arp.keep = 600
net.route.arp.refresh = 600
net.route.arp.useloopback = 1
net.link_layer.generic.ppp.numif = 2
net.link_layer.generic.lo.numif = 1
net.link_layer.generic.pif.numif = 1
net.link_layer.generic.vlan.numif = 4
net.link_layer.generic.gif.numif = 1
hw.machine = i386
hw.model = Intel(R) Xeon(TM) CPU 3.20GHz
hw.ncpu = 4
hw.byteorder = 1234
hw.physmem = -134615040
hw.usermem = -603975680
hw.pagesize = 4096
machdep.console_device = conskbd0
machdep.cntlaltdel = -1
machdep.cntlaltdelcore = 0
machdep.parityerrorpanic = 1
user.cs_path = /usr/bin:/bin:/usr/sbin:/sbin:/usr/contrib/bin:/usr/old/bin
user.bc_base_max = 99
user.bc_dim_max = 2048
user.bc_scale_max = 99
user.bc_string_max = 1000
user.coll_weights_max = 0
user.expr_nest_max = 32
user.line_max = 2048
user.re_dup_max = 255
user.posix2_version = 199212
user.posix2_c_bind = 0
user.posix2_c_dev = 0
user.posix2_char_term = 0
user.posix2_fort_dev = 0
user.posix2_fort_run = 0
user.posix2_localedef = 0
user.posix2_sw_dev = 0
user.posix2_upe = 0
user.stream_max = 20
user.tzname_max = 255


>
> Regards
>
> Ian Barwick
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

--
Member - Liberal International    This is doctor@nl2k.ab.ca Ici doctor@nl2k.ab.ca
God,Queen and country!Never Satan President Republic!Beware AntiChrist rising!
http://www.fullyfollow.me/rootnl2k  Look at Psalms 14 and 53 on Atheism
C'est temps pour le Quebec de dire non a la Parti Qorruption!