Find the answer to your Linux question:
Results 1 to 3 of 3
Hi, I have a dedicated server and it comes with PostgreSQL and MySQL installed on the server. I am native to using MySQL with everything, my custom PHP stuff, phpBB ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie
    Join Date
    Feb 2004
    Posts
    139

    MySQL & PostgreSQL


    Hi,
    I have a dedicated server and it comes with PostgreSQL and MySQL installed on the server. I am native to using MySQL with everything, my custom PHP stuff, phpBB and IPB forums, etc.

    I started up the PostgreSQL service and took it for a test drive with the different things. The speeds were pretty much identical.

    PostgreSQL 7.3.6:
    http://area51.richgannon.net/phpBB2/

    MySQL 3.23.58:
    http://area52.richgannon.net/phpBB2/

    What I am really wondering, is if one is better at certain environments than others. I know MySQL is the most common on webhosts, but should I offer them both to customers? What are the pros and cons of PostgreSQL? Is it worth running both for a webhost? Or is PostgreSQL not really worth the extra RAM/CPU needed to run?

    Thanks for any input.
    If you love something, emerge it

  2. #2
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    PostGres is different from MySQL, it has stored procedures, triggers, and loads of other features not currently in mysql 3.x, and 4.x is only part of the way there.

    The general notion is that mysql is faster, but postgres has features used in larger database applications.

    If or not you should offer PostGres to your customers is something that should be a part of your business plan and I cannot really tell you what to do there. Generally I wouldnt *expect* there to be an everyday demand for postgres hosting especially in a shared hosting environment - only bigger sites where that level of database requirement are a necessitiy may use it.

    Jason

  3. #3
    Linux Newbie
    Join Date
    Feb 2004
    Posts
    139
    Thanks alot for the information, Jason.

    I also found some good articles talking about the two.

    http://www.databasejournal.com/featu...le.php/3288951

    http://www.webtechniques.com/archives/2001/09/jepson/
    If you love something, emerge it

  4. $spacer_open
    $spacer_close

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •