Benjamin Minshall <[EMAIL PROTECTED]> writes: > Seems the problem may be related to a huge global/pgstat.stat file. > Under 8.1.5 it was about 1 MB; now it's 90 MB in 8.2.3.
Yoi. We didn't do anything that would bloat that file if it were storing the same information as before. What I'm betting is that it's storing info on a whole lot more tables than before. Did you decide to start running autovacuum when you updated to 8.2? How many tables are visible in the pg_stats views? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings