From: | Wu Ming <rdyf4ever(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | PostreSQL v9.2 uses a lot of memory in Windows XP |
Date: | 2012-11-12 14:17:42 |
Message-ID: | CAE5Kd6KYScFFupxtXBVvtXdo4mDykkmKnogs8E5AB7Xe+Kwykg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
I had installed postgreSQL v9.2 in Windows XP SP3.
My PC specs:
Processor: Pentium Dual Core 2.09 GHz
RAM: 2GB
The postgreSQL is run as windows service (manual).
The problem is the postgreSQL service uses a lot of memory and lags
the OS if running in long time (about 2 hours or more) so I had to
restart the postgreSQL service everytime it happened. I never do any
big querying process so far. I only ever run it for adempiere ERP
software and a small struts 2 project.
See this screenshot link from the Process Explorer:
http://i45.tinypic.com/vr4t3b.png
You can see that there are a lot of threads spawned. Is the threads
that caused the high memory usage?
Is there a way to decrease the memory usage?
Thanks & Regards,
WM
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-11-12 14:29:11 | Re: PostreSQL v9.2 uses a lot of memory in Windows XP |
Previous Message | Arjen van der Meijden | 2012-11-12 11:38:04 | Re: fast read of binary data |