Aaron Stone wrote:
Wait, I didn't finish that thought :-P
So the necessary rearchitecture would involve delivering the messageblks
first into a memory table, and only copying them into an on-disk table if
there are local recipients. I believe that this method was used in an
early pre-1.0 version of DBMail, and replaced with a locally in-memory
system, which I replaced with the internal user system. My way makes it
possible to store arbitrarily large messages without requiring them to be
in memory all at once, which I think is a pretty important part of the
design. **
PostgreSQL temp tables are not "memory tables", they do and can write to
disk, they are just more efficient since they are designed not to
persist through a crash.
