Re: Reduce maximum error in tuples estimation after vacuum. - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Reduce maximum error in tuples estimation after vacuum.
Date
Msg-id CA+Tgmobii50TnqUyaqJ2hhyP6eWCKth_Kq39KvuSkj=RzeDkZg@mail.gmail.com
Whole thread Raw
In response to Reduce maximum error in tuples estimation after vacuum.  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
On Thu, Jun 27, 2013 at 7:27 AM, Amit Kapila <amit.kapila@huawei.com> wrote:
> Now I can look into it further, I have still not gone through in detail
> about your new approach to calculate the reltuples, but I am wondering
> whether there can be anyway with which estimates can be improved with
> different calculation in vac_estimate_reltuples().

I think this is getting at the threshold question for this patch,
which is whether it's really making things better or just moving the
problems around.  I mean, I have no problem accepting that the new
algorithm is (1) reasonably cheap and (2) better in some cases.  But
if it's worse in other cases, which AFAICS hasn't been discussed, then
it's no good.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Add more regression tests for dbcommands
Next
From: Robert Haas
Date:
Subject: Re: MD5 aggregate