> >In any case, it is hard to see how the present behaviour can be seen as > >desirable. It obviously causes problems at least for new Postgres > >users, and we > >all hope there will be many more of these folks in the future. Thanks > >for considering this. Mark > > Uhmmm... analyze or vacuum on an empty table is fairly pointless. Those > utilities are supposed to be used on tables that have data. > > So the answer is, use them on tables that have data. What the OP seems to be saying is that to him it would make a lot of sense to have vacuum by default not act on empty tables.
Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html