PostreSQL v9.2 uses a lot of memory in Windows XP

Поиск
Список
Период
Сортировка
От Wu Ming
Тема PostreSQL v9.2 uses a lot of memory in Windows XP
Дата
Msg-id CAE5Kd6KYScFFupxtXBVvtXdo4mDykkmKnogs8E5AB7Xe+Kwykg@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostreSQL v9.2 uses a lot of memory in Windows XP  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: PostreSQL v9.2 uses a lot of memory in Windows XP  (Merlin Moncure <mmoncure@gmail.com>)
Re: PostreSQL v9.2 uses a lot of memory in Windows XP  (Craig Ringer <craig@2ndQuadrant.com>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: fast read of binary data
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: PostreSQL v9.2 uses a lot of memory in Windows XP