I finally upgraded from postgres 7.4 to 8.2 and mail inbox loading went from
about 7-10s to 2-3s, so much better, but still not at the same level of 2.0.10
with its <1s loads. I have a feeling that my db structure/schema messed up.
I ran vacuum full analyze; on all the databases, is that all I should do?
Should I reindex or anything, anything to get performance going better.
I would like to make a new structure and then import my data into it. Does
anybody have a good method for doing this. I was thinking of just using
phppgadmin to export data only. and then import it but then the sequences
would be off. does anybody have a good procedure for doing this.
Thanks,
Eric
_________________________________________________________________
Gear up for Halo® 3 with free downloads and an exclusive offer. It’s our way of
saying thanks for using Windows Live™.
http://gethalo3gear.com?ocid=SeptemberWLHalo3_WLHMTxt_2
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
