Re: postgresql on FreeBSD 5.3 and high load

From: Sean Chittenden (sean_at_chittenden.org)
Date: 12/05/04

  • Next message: Claus Guttesen: "Re: postgresql on FreeBSD 5.3 and high load (solved)" 
    Date: Sun, 5 Dec 2004 12:58:42 -0800
To: Claus Guttesen <cguttesen@yahoo.dk>

    >> 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.

    Before I fired that off, I should've asked, if you do:

    SELECT * FROM pg_catalog.pg_locks WHERE granted = FALSE

    Are you getting any rows? If not, slow locks aren't the issue. Have
    you run iostat(1) to see if you're saturating your IO?

    >> 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).

    Look in pg_catalog.pg_stat* for an idea of your workload.

    http://developer.postgresql.org/docs/postgres/monitoring-
    stats.html#MONITORING-STATS-VIEWS-TABLE

    If you can come back with a more specific problem other than "load is
    high," it's much easier to get more precise help regarding whatever the
    problem is. A load of 70 may just mean you've got a damn busy
    database. :) -sc 

    -- 
Sean Chittenden
_______________________________________________
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: Claus Guttesen: "Re: postgresql on FreeBSD 5.3 and high load (solved)"

    Relevant Pages

    • Re: postgresql on FreeBSD 5.3 and high load
      ... > I think spin locks ... > were disabled for amd64. ... until January next year, where the load have ... I'll decrease it to 16384. ...
      (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)