On 10/31/23 08:25, Corey Huinker wrote: > > Attached is v2 of this patch. > > New features: > * imports index statistics. This is not strictly accurate: it > re-computes index statistics the same as ANALYZE does, which is to > say it derives those stats entirely from table column stats, which > are imported, so in that sense we're getting index stats without > touching the heap.
Maybe I just don't understand, but I'm pretty sure ANALYZE does not derive index stats from column stats. It actually builds them from the row sample. > * now support extended statistics except for MCV, which is currently > serialized as an difficult-to-decompose bytea field. Doesn't pg_mcv_list_items() already do all the heavy work? regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
