Re: Tables dissapearing

On Mon, Aug 27, 2007 at 10:03:04PM +0200, Kamil Srot wrote:
> >
> Sure, I ment it like I'll do the FULL vacuum less often than daily and
> do daily the plain vacuum command.

If you have your servers set up correctly, you should never need to
perform VACUUM FULL.

> Well, I do list all databases with the command "psql -U postgres -l -t"
> and with some shell coding I do vacuum all shown databases...
> I don't think there is some problem in it...
>
> If you do see some, can you give me a hint?

I don't think I've seen the script itself. Without seeing it, I can
only guess. But you don't actually need to do that. You should be
able to run vacuumdb -a, and get the result you need.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie