Re: pg_statistic MCVs use float4 but extended stats use float8

2023-02-15 Thread Tomas Vondra
Hi, On 2/15/23 02:20, Justin Pryzby wrote: > It seems odd that stats_ext uses double: > > postgres=# SELECT attrelid::regclass, attname, atttypid::regtype, relkind > FROM pg_attribute a JOIN pg_class c ON c.oid=a.attrelid WHERE > attname='most_common_freqs'; > attrelid | attname

pg_statistic MCVs use float4 but extended stats use float8

2023-02-14 Thread Justin Pryzby
It seems odd that stats_ext uses double: postgres=# SELECT attrelid::regclass, attname, atttypid::regtype, relkind FROM pg_attribute a JOIN pg_class c ON c.oid=a.attrelid WHERE attname='most_common_freqs'; attrelid | attname | atttypid | relkind --