Re: Performance Tuning - Any easy things that I can do ?

Gauthier, Dave escribió:
> analyze?  Does the empirical data the optimizer use develop good queries get updated with/after a restore?

Not automatically, you have to invoke it manually.  (In recent releases,
autovacuum would do it, but 7.1 didn't have it).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.