Re: postgresql on FreeBSD 5.3 and high load

From: Claus Guttesen (cguttesen_at_yahoo.dk)
Date: 12/05/04

  • Next message: Sean Chittenden: "Re: postgresql on FreeBSD 5.3 and high load" 
    Date: Sun, 5 Dec 2004 21:44:34 +0100 (CET)
To: Sean Chittenden <sean@chittenden.org>

    > Have you looked to see if you're using spin locks or
    > not? Search for
    > "amd64 x86_64 spin lock" in PostgreSQL's archives.
    > I think spin locks
    > were disabled for amd64. When you're at a load of
    > 70, look in
    > pg_catalog.pg_locks to see if you have any ungranted
    > locks.

    Thank you for your input.

    Searched postgresl.org's archives, both wihtin and via
    google, but only found information that related
    primarily to Linux.

    >
    > Also, is your application primarily read? You may
    > want to investigate
    > using pgpool as a way of reducing the overhead for
    > connection startup.

    There are more reads than writes, but I haven't found
    the exact numbers (yet).

    > Another option is to use memcached and remove some
    > queries from the
    > database all together. -sc

    I will take a look at these utilities, but will wait
    until January next year, where the load have
    decreased. Right now I'll throw some more hardware at
    it, a quad-opteron which was planned (in May next
    year), and will go through the php-code to optimize.

    I increased the shared_buffers to 65536, but it did
    not change much. I'll decrease it to 16384. Read a
    thread related to 'mbwait postgresql freebsd' which I
    found at freebsd's site. This suggested that a (too)
    high value could be counterproductive.

    regards
    Claus

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

  • Next message: Sean Chittenden: "Re: postgresql on FreeBSD 5.3 and high load"

    Relevant Pages

    • Re: postgresql on FreeBSD 5.3 and high load
      ... >> I think spin locks were disabled for amd64. ... >> using pgpool as a way of reducing the overhead for ... If you can come back with a more specific problem other than "load is ...
      (freebsd-performance)
    • Re: postgresql on FreeBSD 5.3 and high load
      ... > Our postgresql-server hits the wall when we get many ... > serves 11 webservers. ... Have you looked to see if you're using spin locks or not? ... "amd64 x86_64 spin lock" in PostgreSQL's archives. ...
      (freebsd-performance)
    • Re: postgresql on FreeBSD 5.3 and high load
      ... >> Have you looked to see if you're using spin locks or not? ... > stuff is moot on this platform. ... EM64T is Intel's name for amd64, ...
      (freebsd-performance)