Skip site navigation (1) Skip section navigation (2)

Checking query results against selectivity estimate

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Checking query results against selectivity estimate
Date: 2001-07-05 17:37:09
Message-ID: Pine.LNX.4.30.0107051931270.677-100000@peter.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
I don't recall, has it ever been considered to compare the number of
actual result rows against the estimate computed by the optimizer and then
draw some conclusions from it?  Both numbers should be easily available.
Possible "conclusions" might be suggesting running analyze, suggesting
tweaking "M" and "K", assigning an out-of-whack factor to the statistics
(once it goes to infinity (or zero) you do one of the previous things), in
some future life possibly automatically switching to an alternative
statistics model.

Peter Eisentraut   peter_e(at)gmx(dot)net


pgsql-hackers by date

Next:From: Tom LaneDate: 2001-07-05 18:36:21
Subject: Re: Checking query results against selectivity estimate
Previous:From: The Hermit HackerDate: 2001-07-05 17:34:26
Subject: Re: Pg on SMP half-powered

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group