Re: changing max_connections in postgresql on FreeBSD 5.4

From: Jim C. Nasby (decibel_at_decibel.org)
Date: 08/23/05

  • Next message: Jim C. Nasby: "Re: mysql 4.1.13 performance" 
    Date: Mon, 22 Aug 2005 20:27:13 -0500
To: Michael VInce <mv@roq.com>

    On Mon, Aug 08, 2005 at 11:26:37AM +1000, Michael VInce wrote:
    > Also note that I have a MySQL server with a similar table setup and it
    > performs a lot better.

    If you provide example queries that are performing worse than in MySQL
    along with the output of EXPLAIN ANALYZE on them to the PostgreSQL
    performance tuning list I'm sure you'd get some help. Include details
    about your machine configuration and postgresql.conf variables you've
    changed too.

    Also, make sure you're actually running MySQL in such a way that it's
    ACID compliant; it's very easy to configure it so that your data isn't
    safe at all, which would be an apples-oranges comparison to PostgreSQL. 

    -- 
Jim C. Nasby, Database Architect                decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
_______________________________________________
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: Jim C. Nasby: "Re: mysql 4.1.13 performance"

    Relevant Pages

    • Re: Effect of MySQL being acquired by Sun Micro
      ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... I didn't know SQL support was added that late. ...
      (comp.lang.php)
    • Re: Python, xml, databases, ...
      ... I think you want to be clear whether you want a database or not. ... Any machine can run a service (such as MySQL or PostgreSQL), ... both MySQL and PostgreSQL rely on the Cygwin dll. ...
      (comp.lang.python)
    • Re: Looking for a database
      ... >> The obvious choices on fedora will be MySQL and postgresql ... > If I was to chose between Postgresql and another free database it would ... > be between Postgresql and Firebird, ...
      (Fedora)
    • Re: Effect of MySQL being acquired by Sun Micro
      ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... By the time Postgres became PostgreSQL, mSQL already had a strong foothold ...
      (comp.lang.php)
    • Re: pro- foreign key propaganda?
      ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
      (comp.databases.theory)