Re: WIP: Collecting statistics on CSV file data

On 20-09-2011 11:12, Marti Raudsepp wrote:
> 2011/9/12 Etsuro Fujita<fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>:
>> This is called when ANALYZE command is executed. (ANALYZE
>> command should be executed because autovacuum does not analyze foreign
>> tables.)
>
> This is a good idea.
>
> However, if adding these statistics requires an explicit ANALYZE
> command, then we should also have a command for resetting the
> collected statistics -- to get it back into the un-analyzed state.
>
Why would you want this? If the stats aren't up to date, run ANALYZE
periodically. Remember that it is part of the DBA maintenance tasks [1].

[1] http://www.postgresql.org/docs/current/static/maintenance.html

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento