Re: FreeBSD, PostgreSQL, semwait and sbwait!

From: Claus Guttesen (cguttesen_at_yahoo.dk)
Date: 03/23/04

  • Next message: Dror Matalon: "Re: FreeBSD, PostgreSQL, semwait and sbwait!" 
    Date: Tue, 23 Mar 2004 21:49:27 +0100 (CET)
To: Jason Coene <jcoene@gotfrag.com>, freebsd-performance@freebsd.org

    > We're having a substantial problem with our FreeBSD
    > 5.2 database server
    > running PostgreSQL - it's getting a lot of traffic
    > (figure about 3,000
    > queries per second), but queries are slow, and it's
    > seemingly waiting on
    > other things than CPU time.
    > ...
    > It seems that queries are executing fine once they
    > start, but it's taking a
    > while for them to get going, while the postgres

    It may not apply, but is DNS configured correct? Try
    connect with ssh and see if it takes a few sec's
    before you connect.

    Your postgres-info seems fine.

    As a sidenote you may want to copy GENERIC to a new
    file and compile that one instead. During your next
    cvsup GENERIC will be recovered to it's original state
    and your changes will be lost.

    regards
    Claus

    Yahoo! Mail (http://dk.mail.yahoo.com) - Gratis: 6 MB lagerplads, spamfilter og virusscan
    _______________________________________________
    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: Dror Matalon: "Re: FreeBSD, PostgreSQL, semwait and sbwait!"

    Relevant Pages

    • Re: PostgreSQL and Firebird comparison via digg
      ... Do you know if using PostgreSQL a query or connection can have a priority set, so it can run quicker than other queries? ... in a POS system the reporting queries should have lower priority than the generated invoices insert queries. ... I know a lot of people are basing this whole threading thing on when PostgreSQL only ran on windows via cygwin Unix emulation and yes that did suck, but that is a thing of the way way past. ...
      (borland.public.delphi.non-technical)
    • Re: How do I speed up this query ? (1.7M table entries)
      ... Filtering on the bounding square first allows us to use sargable ... > PostgreSQL, Oracle, and to some extent recent versions of MySQL each ... > have spatial index support using r-tree indexes. ... > I thought MS FoxPro was supposed to have some support for distance queries ...
      (microsoft.public.sqlserver)
    • FreeBSD, PostgreSQL, semwait and sbwait!
      ... We're having a substantial problem with our FreeBSD 5.2 database server ... running PostgreSQL - it's getting a lot of traffic (figure about 3,000 ... queries per second), but queries are slow, and it's seemingly waiting on ... It's running FreeBSD 5.2 and PostgreSQL 7.4.1. ...
      (freebsd-performance)
    • Re: OT: MySQL versus PostgreSQL and database design
      ... which you can look up "principles of database normalization". ... why people were dissatisfied with either MySQL or PostgreSQL. ... Then you can direct only updates to the master and all queries to ...
      (rec.crafts.metalworking)
    • Best bit fields implementation under postgres
      ... I'm working on a database (postgresql) structure and some of the ... must store bit fields. ... Later on it must handle queries like "give me ...
      (comp.databases)
    • Quantcast