Re: statistics about tamp tables ...

Alvaro Herrera wrote:
> On Wed, Nov 26, 2003 at 05:34:28PM +0100, Hans-Jürgen Schönig wrote:
> 
> 
>>The reason why I came up with this posting is slightly different: Assume 
>>a JDBC application which works with PostgreSQL + some other database. If 
>>you want to use both databases without PostgreSQL being unnecessarily 
>>slow an implicit mechanism would be better. Because otherwise you will 
>>have an SQL command in there which is off standard - putting a switch 
>>into the application seems to be a fairly ugly solution.
> 
> 
> That's why you delegate the job to something else, like pg_autovacuum or
> cron ...
> 


If you are in the middle of a data mining application using a tmp table 
you don't want to wait for cron ;). You might want the statistics to be 
correct as soon as the table has been created.
Regards,    Hans


-- 
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706 or +43/664/233 90 75
www.cybertec.at, www.postgresql.at, kernel.cybertec.at