Re: Statistics on array values - Mailing list pgsql-performance

Marco Colli <collimarco91@gmail.com> writes:
> Unfortunately I don't get actual improvements. I use PG 11 and I run the
> following commands:
> ALTER TABLE subscriptions ALTER tags SET STATISTICS 1000;
> ANALYZE subscriptions;
> However the bias remains pretty much the same (slightly worse after). Any
> idea?

So what have you got in the pg_stats fields I asked about?
How big is this table anyway (how many rows, how many different tag
values)?

            regards, tom lane