Analyze and vacuum, they are sort of mandatory.... - Mailing list pgsql-hackers

From Mark Woodward
Subject Analyze and vacuum, they are sort of mandatory....
Date
Msg-id 16507.24.91.171.78.1139682819.squirrel@mail.mohawksoft.com
Whole thread Raw
Responses Re: Analyze and vacuum, they are sort of mandatory....  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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?




pgsql-hackers by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Upcoming re-releases
Next
From: Peter Eisentraut
Date:
Subject: Re: Analyze and vacuum, they are sort of mandatory....