Re: Statistics on array values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Marco Colli <collimarco91@xxxxxxxxx> 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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux