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)
    • 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)
    • Re: Using stored procedures in C# for postgreSQL using ODBC
      ... queries for retriving data from database. ... I want to write queries using stored procedures, ... write stored procedures for postgreSQL. ... a full .NET provider, so you don't have to use the slower odbc route. ...
      (microsoft.public.dotnet.framework.adonet)