postgresql query cost values/estimates

From: John Lister <john(dot)lister(at)kickstone(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: postgresql query cost values/estimates
Date: 2012-07-18 12:18:25
Message-ID: 5006A991.3020504@kickstone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi, I was wondering if there are any recommended ways or tools for
calculating the planner cost constants? Also, do the absolute values
matter or is it simply the ratio between them? I'm about to configure a
new server and can probably do a rough job of calculating them based on
supposed speeds of the various components but wondered if anyone uses
more accurate methods?

Thanks

John

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2012-07-18 12:26:02 Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous Message Sergey Konoplev 2012-07-18 12:08:47 Re: Process 11812 still waiting for ExclusiveLock on extension of relation