- June 5, 2009 at 9:11 am #30988
I note that we have some 12 instances of postgres.exe running on our server, taking up a shed load of RAM. Is this normal? What, if anything, should be done about it?
RegardsJune 5, 2009 at 3:03 pm #32212
Yes this is normal. The database engine spawns multiple instances of the postgres.exe process. The more users concurrently connected, the more instances there will be. Each process instance will also use different amounts of memory depending on their function (e.g updating a single record or performing a large query).
When you say ‘shed loads’, how much RAM is in fact being used? If the total is over 1Gb then that would be out of the ordinary and we can reduce it for you by tweaking the PostgreSQL engine seetings.
Please feel free to give our helpdesk a call if you want us to connect remotely to take a look.
You must be logged in to reply to this topic.