marc at electronics-design
Apr 14, 2008, 3:58 AM
Post #1 of 1
(163 views)
Permalink
|
Hi,
I'm glad to report dbmail 2.2.10 seems to be happy runnig with postgres 8.3.
A nice feature of 8.3, is having (per default) statistics on indexes
and their use. Although I mostly have pop3 clients, there are a few
imap ones. But below are my index logs for indexes larger than 1 MB.
One can see here that dbmail_headervalue_3 and dbmail_headervalue_1
is not used at all.
--
Met vriendeeime | reltuples | ratio | size |
idx_scan | read_per_scan | fetched_per_scan
----------------------------------------------+-----------+-------+-------+----------+---------------+------------------
pg_toast_16488 | 789237 | 2067 |1.519 | | |
dbmail_headervalue | 471822 | 126 |0.056 | | |
dbmail_messageblks | 60211 | 920 |0.052 | | |
dbmail_headervalue_3 | 471822 | 98 |0.043 | 0 | |
pg_toast_16488_index | 789237 | 23 |0.017 | | |
dbmail_headervalue_1 | 471822 | 32 |0.014 | 0 | |
dbmail_envelope | 36769 | 377 |0.013 | | |
dbmail_headervalue_2 | 471822 | 23 |0.010 | 50416 | 35 | 35
dbmail_headervalue_pkey | 471822 | 23 |0.010 | 0 | |
dbmail_tofield | 39404 | 80 |0.003 | | |
dbmail_messages | 28902 | 97 |0.003 | | |
dbmail_fromfield | 28759 | 88 |0.002 | | |
dbmail_subjectfield | 28755 | 80 |0.002 | | |
dbmail_datefield | 36714 | 52 |0.002 | | |
dbmail_physmessage | 28818 | 61 |0.002 | | |
dbmail_referencesfield | 17864 | 95 |0.002 | | |
dbmail_tofield_3 | 39404 | 43 |0.002 | 0 | |
dbmail_messageblks_physmessage_is_header_idx | 60211 | 27 |0.002 | 24 | 1 | 1
dbmail_messages_4 | 28902 | 55 |0.001 | 0 | |
dbmail_subjectfield_2 | 28755 | 54 |0.001 | 0 | |
dbmail_referencesfield_1 | 17864 | 81 |0.001 | 143 | 0 | 0
dbmail_messageblks_physmessage_idx | 60211 | 23 |0.001 | 1171 | 2 | 1
dbmail_messageblks_pkey | 60211 | 23 |0.001 | 0 | |
dbmail_fromfield_2 | 28759 | 45 |0.001 | 0 | |
dbmail_referencesfield_2 | 17864 | 72 |0.001 | 0 | |
dbmail_tofield_1 | 39404 | 32 |0.001 | 143 | 1 | 1
dbmail_datefield_1 | 36714 | 32 |0.001 | 143 | 1 | 1
dbmail_envelope_1 | 36769 | 32 |0.001 | 143 | 1 | 1
dbmail_tofield_2 | 39404 | 27 |0.001 | 0 | |
jke groet,
Marc Dirix
Electronics Design
Graaf Wolter Hoenstr 2
6243 BE Geulle
Nederland.
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev[at]dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
|
