Francisco Reyes <lists(at)natserv(dot)com> writes:
> My alternative is to use delete from <table>. Besides been slower I wonder
> if this would not make my "vacuum analyze" run much slower.
Consider TRUNCATE TABLE, also. However, that's not transactional,
so the drop/create/fill might be a better bet if you are worried
about bad data during the fill.
regards, tom lane