Hello Matthew, Second reply to this mail:
>>Ok, I'm running this on Windows using Cygwin postgres / dbmail, >>everything is usually 10 to 100 times slower, but I know that database >>applications can run fast on Windows too. Sure, Cygwin slows down >>things. I installed it on the Windows box for testing, at least it >>builds ok and it runs. But often dbmail seems to hang. It finally >>finishes the work but I suspect htere to be some serious problems. > At this point I would recomend installing the PostgreSQL 8.0 beta that > has native support for Windows. Even though it's still a beta I think > it performs better and is probably more reliable than the cygwin port. > Please give it a try and let me know if you are still having problems. I have the native Windows version of postgres installed now. It is still very slow. I did a `select * from dbmail_messageblks` and it lasts about two minutes to fetch 100 rows! This is very slow, and I don't think that the Cygwin version is much slower here. Why is this so slow? This makes me think about other options. Wouldn't it be faster to store the actual messages on the harddisk? Gerrit -- =^..^=