Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2013
    Posts
    9

    Unanswered: Performance in PostGreSQL

    Hello,

    I'm doing some performance testing (INSERT) in some banks and PostgreSQL performance compared to other banks as SQL Server 2012, Sybase ASA 16 and ASA SyBase 9, has been insignificant. I am new to PostgreSQL but I tried to improve some parameters file PostgreSQL.conf, got an improved performance but still remains very low. Does anyone have any tips on how to improve the performance of PostgreSQL or actually it is much lower than other banks.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Check these links

    https://wiki.postgresql.org/wiki/Per...e_Optimization
    http://www.postgresql.org/docs/curre...ance-tips.html

    You will need to post a concrete question, currently it's impossible to answer.

    For details on how to ask a performance related question please read this:
    https://wiki.postgresql.org/wiki/Slow_Query_Questions

    P.S.: it's either Postgres or PostgreSQL, but never PostGreSQL
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Jun 2013
    Posts
    9

    Tuning on insert PostgreSQL

    Hello,
    *
    What postgresql.conf parameters directly influence the insert, because I wanted to improve performance during INSERTs? Anyone can help ...

Posting Permissions

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