Analyze and vacuum, they are sort of mandatory....

Started by Mark Woodwardalmost 20 years ago1 messages
#1Mark Woodward
pgsql@mohawksoft.com

I was think about how forgetting to run analyze while developing a table
loader program caused PostgreSQL to run away and use up all the memory.

Is there some way that postges or psql can know that it substantially
altered the database and run analyze?

I know this is a kind of stupid question, but postgresql does not behave
well when the system changes in a major way without at least an analyze.
There must be something that can be done to protect the casual user (or
busy sometimes absent minded developer) from these dangerous edge
conditions?