John Hansen wrote:
Q: why is the headers split from the message? If it's an attempt to
minimize disk io when only fetching imap headers, then that will only do
that ever so slightly, since it will still have to do lots of seeks, and
for postgresql it will choose not to use an index if the planner
realizes that a sequence scan might be faster. Again, for PostgreSQL you
may be able to improve on this by clustering the table on an index over
is_header...
Q: Why not add to the messageblks table fields containing parsed
headers:
IMO every header field should be stored seperately in the database in
addition to storing the full message includig the header. After all the
mails need to be parsed once, having the headers with reference to the
actual message would enable generating interesting reports.
Gerrit
--
=^..^=
