Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2014
    Posts
    1

    Unanswered: Less cost and more time

    Hi guys,

    I have a problem here that I can't deal with.

    I have a complex query that take too long to execute. I've tried to optimize it writing a new one, then, I've ran explain.
    The new query cost less than the first, but the new one take more time than the other to complete running.
    Someone can help me? Which one should I use? How can I know which one is better?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Please read this:

    https://wiki.postgresql.org/wiki/Slow_Query_Questions

    and then add the missing information
    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

Tags for this Thread

Posting Permissions

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