On Mon, 2005-08-08 at 15:30, Neil Conway wrote: > Scott Marlowe wrote: > > You might want to schedule analyzes to run every thirty minutes or every > > hour. > > I doubt that is necessary or wise. Rerunning ANALYZE should only be > necessary when the distribution of your data changes significantly -- > e.g. after a bulk load or deletion of a lot of content. IMHO In most > circumstances, running ANALYZE once a day is more than sufficient.
I just let pg_autovacuum decide for me. Really is easier than doing it yourself. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
