I'd prefer ALTER VIEW SET ANALYZE=true; or CREATE/DROP ANALYZE ;
Also it should be possible to change statistics target for analyzed columns.
Such a statement would allow to analyze multi-table correlations. Note that
for view planner should be able to use correlation information even for
queries
Alvaro Herrera writes:
> I've been giving this some thought and tried several approaches. In the
> end the one that I like the most is raising autovacuum_naptime to a
> reasonable value for the exiting number of databases. The only problem
> I have with it is that it's trivial to change it in th
Tom Lane escribió:
> Bingo, that's surely exactly what was happening to the OP. He had 2000
> databases and naptime at (I assume) the default; so he was rerunning
> rebuild_database_list every 100ms.
>
> So that recovery code path needs some more thought. Maybe a lower bound
> on how often to d
What version of Postgres are you using?
8.3.5 on FreeBSD amd64
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
