Zdenek Kotala escribió:
> Gregory Stark napsal(a):
>> AFAIK we can't easily connect to the new database and do some fiddling with
>> it, can we? If we could we could check if there are any non-empty indexes
>> which depend on the collation and only print the warning if we find any (and
>> even mark them invalid).
>
> Autovacum uses InitPostgres function to swith to another database. I'm
> not sure how much safe it is in create database command and when we are
> already switched we can reindex affected indexes.
It's only supposed to work if you're not previously connected to any
database. (Autovacuum never "switches to another database"; any
particular worker only connects to a single database).
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support