Now I am back, next thing. Final PGS tuning.

Ok,

I have left the previous thread. After changing the last permissions, even
though it said Access Denied, suddenly PostgreSQL started to work again. I
will not dig any further to the strangeness.

I copied the content of the.conf from tuning wizard and restarted. Still
working!

I want to say thanks to several people on that thread :) Thank you!

I would like to further tune the tuning wizards recommendations though. I
think it put itself on the lower scale.

I have 8GB memory, Intel Quad Core 2.4Ghz with 8MB L2 cache. I am running
Windows Web Server 2008 x64 and will be running a Java (64 bit version)
application.

I want to give the java app room for working on 2-3GB. The operating system
is currently consuming around 1GB but lets give it a little more room. Lets
give it a total of 2GB.

That leaves 8-3-2 = 3 GB for PostgreSQL alone. Sounds good?

Here is my config file :

http://85.235.31.35/resources/postgresql.conf

I see there is a setting

*max_connections = 100*

What does this do? Should I be looking at this as max similtaneous queries ?
is 100 really enough? I think I want to max this more.

I am looking for a worst scenario around like 50-100 similitaneous user
clicks (per second?). But the querying might be around like 200 queries per
seocond, not really, but I want to be prepared. :)

I would appreciate if could have a discussion on these topics. On whats
important and whats not.

Here is some other settings I am thinking about :

*effective_cache_size = 449697*

is this kilo bytes ? Is this a good value?

*maintenance_work_mem = 16384 *

*work_mem = 1024 # I think this is kb. Way to low, right? What is a better
value?*

*shared_buffers = 1024 # min 128kB or max_connections*16kB ## Also to low.
Right? I've got 3GB to work with!*

*wal_buffers = 256 # Also kB...*

Please give your thoughts. I was also wondering about the Vacuum, force
reindex and stuff. Are those things good to run once in a while? Force
sounds a little brutal though!

Something else I should consider?

/ Jennifer