yep - we use analyze and check the output. It's version 8.4.5 so no fsm
issues.
thanks, Maria
On 4/6/11 11:33 AM, Kevin Grittner wrote:
"Maria L. Wilson"<maria.l.wilso...@nasa.gov> wrote:
Autovacuum is not running - but regular vacuums are being done
twice daily.
Is the ANALYZE keyword used on those VACUUM runs? What version of
PostgreSQL is this. If it's enough to need fsm settings, do you run
with the VERBOSE option and check the end of the output to make sure
they are set high enough?
-Kevin
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
