On Thu, Aug 9, 2012 at 12:44 AM, Alexander Korotkov <aekorotkov(at)gmail(dot)com>wrote:
> My conclusion is so, that current errors are probably ok for selectivity
> estimation. But taking into attention that generated datasets ideally fits
> assumptions of estimation, there could be room for improvement. Especially,
> it's unclear why estimate for "<@" and "@>" have much greater error than
> estimate for "&&". Possibly, it's caused by some bugs.
ITSM, I found reason of inaccuracy. Implementation of linear interpolation
was wrong. Fixed version is attached. Now, need to rerun tests, possible
refactoring and comments rework.
With best regards,
In response to
pgsql-hackers by date
|Next:||From: Dean Rasheed||Date: 2012-08-12 21:14:06|
|Subject: Re: Proof of concept: auto updatable views|
|Previous:||From: Tom Lane||Date: 2012-08-12 14:39:23|
|Subject: Re: default_isolation_level='serializable' crashes on Windows|