On Fri, Dec 1, 2006, Matthew O'Connor <[email protected]> said: > Totally non-scientific and based on my memory, after I got the process > down (I scripted everything on a test server), it took me maybe about 2 > hours for about 6G of data on an 64 with a decent SATA drive, using > PostgreSQL 8.1. It was a lot slower, but just before 2.2 was release > Paul made a significant speed-up in the envelope created code.
Is the schema and dbmail-util -ay, or just one or the other? > I highly recommend testing your upgrade on a test server, I ran into > many problems before I finally got up an running on 2.2, and 2.2 daemons > can *NOT* run against a 2.0 database. The issue isn't if we can run 2.2 daemons on a 2.0 database; what's in question is if DBMail 2.2 can run with all 2.2 header tables emptied out. So the process that I'm hoping will be possible (but haven't tested at all!), given that we start with 2.0 daemons and 2.0 database: Add new 2.2 columns and tables, while 2.0 services are running. Take down 2.0 services. Update messageblks columns, total read-write locks at this time. Start up 2.2 services. Generate header cache table entries, while 2.2 services are running. The goal is to minimize downtime to the text->bytea conversion time. I do not know if this will actually work. If someone can try this on a backup and report back, I would greatly appreciate the data. Aaron
