db performance

We have several postfix transport gateways on different networks all
working with local amavisd-maia+SA using a remote postgresql backend at
one location. I am getting delays in the queues on a gateway server at a
remote site since we added more memory to the db server. After seeing
the issues of "SA TIMED OUT" in the logs, seems this was happening prior
to the upgrade, but never to the extent, I guess, to delay much mail.
Queues on a gateway of the same network as the db server working fine,
but messages with the timeouts differ from one server to another.

After reading tuning, it suggests the SWAP should be double RAM.
According to dmesg...

real memory = 3220635648 (3071 MB)
avail memory = 3150565376 (3004 MB)

we have 3GB of RAM available with actually 4GB physical RAM installed?
Anyway, the SWAP is only 2GB, even with the average usage shown here,
will increasing SWAP to 6-8GB help?

last pid: 49828; load averages: 0.23, 0.21, 0.18 up 8+18:33:08 15:42:23
184 processes: 5 running, 158 sleeping, 21 waiting
CPU states: 2.6% user, 0.0% nice, 1.0% system, 0.0% interrupt, 96.4% idle
Mem: 446M Active, 1646M Inact, 236M Wired, 138M Cache, 112M Buf, 30M Free
Swap: 2048M Total, 164K Used, 2048M Free

I also have assumed in the past that db performance could be better if I
get off the system RAID-5 and put it on 1+0? The system has 4 SATA
drives.

All servers running FreeBSD 6.2 and latest ports of postfix+amavisd-maia
+SA+ClamAV. Thanks for any input.

--
Robert

_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • RE: IPNAT / IPF / rdr issue
    ... All your clients are on the LAN behind the gateway correct. ... > request has to go to your ISP DNS server to get your public ip ... > block out log first quick on dc0 all ...
    (freebsd-questions)
  • Re: Default Gateway on VPN subnets
    ... Now I understand that you are using the TZ170 VPN routers to establish the ... Once the default gateway of the remote 2003 server was automatically ... to access the internet or the SBS network? ...
    (microsoft.public.windows.server.sbs)
  • RE: ISA 2004 Firewall Client and ActiveSync 4.2
    ... at home in my WLAN all internet ... that killing my default gateway is not the way ... gateway and the appropriate DNS server entries. ... server internal IP then your client works as a secureNAT client and you're ...
    (microsoft.public.isa.clients)
  • Re: Half Bridge mode and multi-homed box
    ... The router takes all the authentication and link negotiation burden ... > laptop screen whilst I tried to replicate it on the server. ... helldesk of provider) from whoever remembers it for too long. ... The provider's gateway is on a completely different ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Half Bridge mode and multi-homed box
    ... The router takes all the authentication and link negotiation burden ... > that the server somehow doesn't ask for a default gateway. ... I tried putting the default route that the laptop gets into rc.conf. ...
    (comp.unix.bsd.freebsd.misc)