pwadas at jewish
Jun 17, 2009, 10:22 PM
Post #11 of 18
(745 views)
Permalink
|
here you are - one user, 1GB mail moved to DB, one folder (inbox), all
(actually there's 2-3 users, anyway they're all are just tests, and
remaining both does not contain anything).
echo "select 'name' as name ,-1 as ile `cat tblist|while read line; do
echo
"union select '$line' as name, count(*) from $line as ile "; done` order
by ile asc "| psql -U postgres mydb
name | ile
---------------------------+-------
name | 0
dbmail_acl | 0
dbmail_aliases | 0
dbmail_auto_notifications | 0
dbmail_auto_replies | 0
dbmail_keywords | 0
dbmail_messageblks | 0
dbmail_pbsp | 0
dbmail_replycache | 0
dbmail_sievescripts | 0
dbmail_usermap | 0
dbmail_users | 6
dbmail_mailboxes | 10
dbmail_subscription | 10
dbmail_replytofield | 56
dbmail_messages | 56
dbmail_headername | 82
dbmail_ccfield | 111
dbmail_referencesfield | 189
dbmail_subjectfield | 992
dbmail_datefield | 994
dbmail_physmessage | 994
dbmail_fromfield | 994
dbmail_envelope | 1057
dbmail_tofield | 5011
dbmail_mimeparts | 10001
dbmail_partlists | 11467
dbmail_headervalue | 18115
(28 rows)
On Wed, 17 Jun 2009, Jonathan Feally wrote:
> What tables still have a lot of rows?
> select count(*) from dbmail_xxx;
>
> For a single user, you should probably have <10 rows in all of the
> tables. Let me know what tables still have more than that.
>
> -Jon
>
> Piotr Wadas wrote:
> >
> >>> Garbage collection on dbmail_mimeparts is still missing.
> >>>
> >
> > Shall I expect the same behaviour, no matter what kind of backend
> > (mysql/pgsql/sqlite) I'll use?
> >
> > Any simple sql hint to cleanup this table manually, something like
> >
> > delete
> > from dbmail_mimeparts
> > where
> > message_id
> > is not in ( select message_idnr from dbmail_messages )
> >
> > or similar?
> >
>
>
>
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
|
