|From:||Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>|
|Cc:||Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Dilip kumar <dilip(dot)kumar(at)huawei(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andreas Karlsson <andreas(at)proxel(dot)se>|
|Subject:||Re: Selectivity estimation for inet operators|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
Emre Hasegeli <emre(at)hasegeli(dot)com> writes:
> [ inet-selfuncs-v14.patch ]
After further reflection I concluded that the best way to deal with the
O(N^2) runtime problem for the join selectivity function was to set a
limit on the number of statistics values we'd consider, as was discussed
awhile back IIRC. We can easily consider just the first N values of the
MCV arrays, since those are sorted by decreasing frequency anyway. For
the histogram arrays, taking every K'th value seems like the thing to do.
I made the limit be 1024 elements as that seemed to give an acceptable
maximum runtime (a couple hundred msec on my machine). We could probably
reduce that if anyone feels the max runtime needs to be less.
I had to drop the idea of breaking out of the histogram loop early as that
didn't play nicely with the decimation logic, unfortunately.
Anyway, pushed. Thanks for your perseverance on this!
regards, tom lane
|Next Message||Bruce Momjian||2015-04-01 22:26:00||Re: pg_upgrade needs postmaster [sic]|
|Previous Message||Christoph Berg||2015-04-01 20:11:52||Re: Re: [pgsql-pkg-debian] Updated libpq5 packages cause connection errors on postgresql 9.2|