1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL vs PostgreSQL

Discussion in 'Databases' started by wryfhk22, Apr 14, 2011.

  1. #1
    which is better when it comes to performace? MySQL or PostgreSQL? :p
    any input is welcome :D tnx :p
     
    wryfhk22, Apr 14, 2011 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    AstarothSolutions, Apr 15, 2011 IP
  3. EitanXOR

    EitanXOR Greenhorn

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    In my personal experience, Postgres is much more scalable and has much deeper level of optimization that can be done by the developers. It also provides a lot of features that MySQL simply doesn't have - Arrays, custom aggregation functions, interval datatypes, advanced datetime function, its 'programming' language (PL/PgSQL) is amazing, better trigger handling, and much more.
     
    EitanXOR, Apr 16, 2011 IP
  4. mygold

    mygold Peon

    Messages:
    1,164
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #4
    MySQL is better than PostgreSQL. This is from my point view.
     
    mygold, Apr 25, 2011 IP
  5. walks_alone

    walks_alone Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Ms sql is better:)
     
    walks_alone, Apr 26, 2011 IP
  6. Kiopa_Matt

    Kiopa_Matt Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Granted, PostgreSQL does contain more features, but I still think mySQL is a better choice for 99.5% of online operations out there.
     
    Kiopa_Matt, May 30, 2011 IP
  7. b10

    b10 Peon

    Messages:
    755
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    PostgreSQL is always fast for its performance
     
    b10, May 31, 2011 IP
  8. vipinRaj

    vipinRaj Member

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #8
    PostgreSQL is better and feature rich than MySQL. Especially, if you want some spatial data manipulation you can use the powerfull postgres extension postGIS
     
    vipinRaj, Oct 3, 2013 IP
  9. nickspring

    nickspring Member

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    48
    #9
    PostgreSQL is better for some types of web-services, but MySQL is faster for read-operation and for the most websites.
     
    nickspring, Oct 3, 2013 IP
  10. khodem

    khodem Well-Known Member

    Messages:
    206
    Likes Received:
    8
    Best Answers:
    3
    Trophy Points:
    120
    #10
    it all depends on what you are using it for? there is many factor in comparison but over all PostgresSQL is much much better both with optimization option and also for performance with procedure language there is many features that postgress have but not mySQL
     
    khodem, Dec 8, 2013 IP
  11. Seym

    Seym Greenhorn

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    Digital Goods:
    1
    #11
    You can use MariaDB which is a fork of MySql [Practically The Same] which is definitely better that PostgreSql.
     
    Seym, Dec 12, 2013 IP