Gerrit P. Haase wrote:
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?
Strange, that is way outside the bounds of the performance I would
expect. In the performance testing that I have seen comparing the
PostgreSQL native win32 port against the linux port the performance is
comparable, the linux version usually being a little faster but not that
much.
Are you sure there aren't any problems with your PC? Have you run
memtest86? What type of hardware are you on? Have you vacuumed and
analyzed the tables lately?
This makes me think about other options. Wouldn't it be faster to
store the actual messages on the harddisk?
They are stored on the hard disk ;-) They are just using a database to
manage what's on the disk.
Matthew
