After you run this migration you need to run 'dbmail-util -by' and wait for all headercaches to be re-generated.
Going back afterwards is possible, but not trivial. Please wait until I merge this with the master branch. For now: it's experimental. That said, I don't see any downside to this change. I like it. It /should/ improve storage and speed. If this works out we may have to apply this same pattern to the other caching tables - maybe. Jorge Bastos wrote: > Paul, > After this migration, there's no turning back, correct? > I'm asking this 'cause I can be a tester, and I have to wait to know if it > is a bit stable. > > >> -----Original Message----- >> From: dbmail-dev-boun...@dbmail.org [mailto:dbmail-dev- >> boun...@dbmail.org] On Behalf Of Paul J Stevens >> Sent: terça-feira, 27 de Janeiro de 2009 16:06 >> To: dbmail-dev@dbmail.org >> Subject: [Dbmail-dev] [SCM]Paul's DBMail tree branch, header, updated. >> f7176036b374ac716181d7709885a621f2de07a4 >> >> This is an automated email from the git hooks/post-receive script. It >> was >> generated because a ref change was pushed to the repository containing >> the project "Paul's DBMail tree". >> >> The branch, header has been updated >> via f7176036b374ac716181d7709885a621f2de07a4 (commit) >> via 512772a791ed80ac0364510ee5c796612a64883c (commit) >> via cc6c8a0116c3c98dc792fd25d7f8f7b22dbf6168 (commit) >> via 1c5e31890e7cf07f603484d639e49e06d1e2fe6c (commit) >> from ec2257b112034356671e54b685d14b1c5f7e557c (commit) >> >> Those revisions listed above that are new to this repository have >> not appeared on any other notification email; so we list those >> revisions in full, below. >> >> - Log ----------------------------------------------------------------- >> commit f7176036b374ac716181d7709885a621f2de07a4 >> Author: Paul J Stevens <p...@nfg.nl> >> Date: Tue Jan 27 17:05:42 2009 +0100 >> >> minor edit >> >> commit 512772a791ed80ac0364510ee5c796612a64883c >> Author: Paul J Stevens <p...@nfg.nl> >> Date: Tue Jan 27 16:50:21 2009 +0100 >> >> add sqlite migration >> >> commit cc6c8a0116c3c98dc792fd25d7f8f7b22dbf6168 >> Author: Paul J Stevens <p...@nfg.nl> >> Date: Tue Jan 27 16:25:24 2009 +0100 >> >> add mysql migration >> >> also rename the postgresql migration, and leave the >> dbmail_headername >> table intact >> >> commit 1c5e31890e7cf07f603484d639e49e06d1e2fe6c >> Author: Paul J Stevens <p...@nfg.nl> >> Date: Tue Jan 27 15:40:18 2009 +0100 >> >> fix typo >> >> ----------------------------------------------------------------------- >> >> Summary of changes: >> sql/mysql/2_3_5-2_3_6.mysql | 41 +++ >> sql/mysql/create_tables.mysql | 38 ++- >> ...ance_header_storage.pgsql => 2_3_5-2_3_6.pgsql} | 13 - >> ...ate_tables-header_single_instance_storage.pgsql | 379 ------------ >> -------- >> sql/postgresql/create_tables.pgsql | 40 ++- >> sql/sqlite/2_3_5-2_3_6.sqlite | 168 +++++++++ >> sql/sqlite/create_tables.sqlite | 109 +++++-- >> src/dbmail-mailbox.c | 2 +- >> src/dm_db.c | 2 +- >> 9 files changed, 342 insertions(+), 450 deletions(-) >> create mode 100644 sql/mysql/2_3_5-2_3_6.mysql >> rename sql/postgresql/{2_3_5-single_instance_header_storage.pgsql => >> 2_3_5-2_3_6.pgsql} (78%) >> delete mode 100644 sql/postgresql/create_tables- >> header_single_instance_storage.pgsql >> create mode 100644 sql/sqlite/2_3_5-2_3_6.sqlite >> >> >> hooks/post-receive >> -- >> Paul's DBMail tree >> _______________________________________________ >> Dbmail-dev mailing list >> Dbmail-dev@dbmail.org >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
