There are numerous things that aren't working in case of a Windows setup (maybe I should add a slide on this to this presentation...). To start with file uploading is all screwed up and I still cannot get it to work for binary files (it sortof works for text files though) -- hence no real file sharing, portrait uploads, WimpyPoint backgrounds, etc.

As far as Postgres is concerned, I would not say that it is a heavy application: on my laptop it only takes about 14Mb right now for all 3 pools. If you find Postgres being slow in fetching some data (I had a problem with employee admin view in intranet module), try tweaking some of Postgres parameters, especially sort_mem and shared_buffers in /usr/local/pgsql/data/postgresql.conf. Default values that Cygwin package comes with a too low ( I think that sort_mem was lower than 4Mb). Here's my current values:

#
#       Performance
#
sort_mem = 16384
shared_buffers = 64 # min 16
fsync = false

[09/Jul/2001:09:30:38][416.375][-main-] Error: Your Postgres driver is too old. You need to update.
[09/Jul/2001:09:30:38][416.375][-main-] Notice: database problem found; Sourcing the installer.

            if { [catch { ns_pg_bind 1row $db "select count(*) from pg_class" }] } {
                set my_errors "Your Postgres driver is too old.  You need to update."
                set my_error_p 1
            }

1. I think that file upload is more like AOLServer on Windows issue. There actually is a patch out there on sourceforge (fixes form.tcl to work better with mulitpart forms -- basically opens all files in binary mode not to get tricked by

Damn, I wonder where did the rest of my comment go... Anyway, binary file issues may be a mixture of AOLServer and ACS. I just tried it again, to refresh my memory, and I guess I found a fix, at least for new-file-storage.

The problem is that on brain-dead win platform a binary file should be opened as binary (this has no effect fo "real" OS's). This adding the following string:

  fconfigure $file_to_return -translation binary