On Freitag, 14. September 2007 01:14 Eric Hiller wrote: > I ran vacuum full analyze; on all the databases, is that all I should > do?
I've increased default_statistics_target = 1000 (was 10 before) and after vacuum full analyze, it's a huge benefit. See my mail from 27.Aug. to see the details. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
pgp1n7HF73Ttc.pgp
Description: PGP signature
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
