Forum OpenACS Q&A: OpenACS on Windows

Collapse
4: OpenACS on Windows (response to 1)
Posted by Andrei Popov on

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
See this guide for additional tips'n tricks of Postgres tuning.