Hi Tom, Le jeudi 14 septembre 2006 à 10:13 -0400, Tom Lane a écrit : > =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <[EMAIL PROTECTED]> writes: > > I migrated Postgres server from 7.4.6 to 8.1.4, But my server is > > completely full, by moment load average > 40 > > Did you remember to ANALYZE the whole database after reloading it? > pg_dump/reload won't by itself regenerate statistics. > > regards, tom lane I tested, dump + restore + vaccumdb --analyze on all databases but no change ...
Cheers,
--
Jérôme,
python -c "print '@'.join(['.'.join([w[::-1] for w in p.split('.')]) for
p in '[EMAIL PROTECTED]'.split('@')])"
signature.asc
Description: Ceci est une partie de message numériquement signée
