s.com.au]
Sent: Wednesday, August 26, 2009 7:37 PM
To: WANGRUNGVICHAISRI, SHIVESH
Cc: pgsql-bugs
Subject: RE: [BUGS] BUG #4996: postgres.exe memory consumption keeps going up
On Wed, 2009-08-26 at 16:51 -0700, WANGRUNGVICHAISRI, SHIVESH wrote:
> However, I still insist that potentially the Po
Craig,
I looked into this problem extensively today, and here's what I found.
It's not PostgreSQL that is leaking memory; it's the fact that our
application is also using PostGIS 1.3.6.
We have modified the test program such that it clearly shows memory leak
when PostGIS is used.
Below is the e
On Wed, 2009-08-26 at 16:51 -0700, WANGRUNGVICHAISRI, SHIVESH wrote:
> However, I still insist that potentially the PostgreSQL community might
> want to look into why making use of libpq causes the client program's
> memory consumption to keep growing. This can be easily observed using
> the earli
On Wed, 2009-08-26 at 16:51 -0700, WANGRUNGVICHAISRI, SHIVESH wrote:
>
> So my claim that PostgreSQL was leaking memory was not true, and I do
> apologize.
>
No problem. That's why it's important to look into these things - so we
find out.
> However, I still insist that potentially the Postgre
Greg Stark wrote:
I don't know where to find Postgres logs on Windows but it
shouldn't be hard to find.
$(INSTALLDIR)/data/pg_log
D:\postgres\8.3\data\pg_log on mine here.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.po
On Wed, Aug 26, 2009 at 4:38 PM, Craig
Ringer wrote:
> If it is in fact postgres.exe that crashes at some point, it'd also
> *REALLY* help to have a backtrace of the crash.
If Postgres crashes due to running out of memory it prints a memory
dump to its log which would (hopefully) make it clear whe
On Wed, 2009-08-26 at 07:09 -0700, WANGRUNGVICHAISRI, SHIVESH wrote:
> I also did use the Process Explorer as you suggested; I'm sorry I
> didnt mention that in the post. As I mentioned before in the zip file,
> the working set kept growing.
Yes, but does the *private* working set? The screen sho
On 26/08/2009 9:25 AM, WANGRUNGVICHAISRI, SHIVESH wrote:
Hi,
I have uploaded everything that you should need here:
http://www.filefactory.com/file/ah334c6/n/Pgsql_Leak_zip
I notice that you used the Windows Task Manager to monitor memory usage,
rather than Process Explorer. There's a reason
t you find.
Thanks,
S.
-Original Message-
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Saturday, August 22, 2009 8:58 PM
To: WANGRUNGVICHAISRI, SHIVESH
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4996: postgres.exe memory consumption keeps going up
> Pleas
On 23/08/2009 12:42 PM, Greg Stark wrote:
On Sun, Aug 23, 2009 at 4:48 AM, Craig
Ringer wrote:
Interestingly, though, the test program does appear to be leaking - at
least, the peak working set slowly climbs. It's all private working set. Not
sure why yet since the memory use looks like it _sho
On Sun, Aug 23, 2009 at 4:48 AM, Craig
Ringer wrote:
> Interestingly, though, the test program does appear to be leaking - at
> least, the peak working set slowly climbs. It's all private working set. Not
> sure why yet since the memory use looks like it _should_ be constant.
How does the return v
Please launch Process Explorer and then your test program. Double-click
on the postgres.exe backends to open info windows for them and do the
same for the test program. Take a screenshot (windows-prtscrn) and save
it. Let the test run a while and do the same thing occasionally to keep
a record.
On 19/08/2009 11:50 PM, Shivesh Wangrungvichaisri wrote:
The following bug has been logged online:
Bug reference: 4996
Logged by: Shivesh Wangrungvichaisri
Email address: s...@appsig.com
PostgreSQL version: 8.3.7
I ran your test program on 8.4.0 (not 8.3.7 as you used), and
On Wed, Aug 19, 2009 at 4:50 PM, Shivesh
Wangrungvichaisri wrote:
> 8) In our real application, since we INSERT a large amount of data per
> query, as well as SELECT a large amount of data per query, the memory leak
> is much worse, and postgres.exe crashes after its memory consumption has
> reache
On 23/08/2009 10:37 AM, Craig Ringer wrote:
On 19/08/2009 11:50 PM, Shivesh Wangrungvichaisri wrote:
Logged by: Shivesh Wangrungvichaisri
Email address: s...@appsig.com
PostgreSQL version: 8.3.7
Operating system: Windows XP x64 / Windows 7 x64
Description: postgres.exe memory consumption keeps
On 19/08/2009 11:50 PM, Shivesh Wangrungvichaisri wrote:
Logged by: Shivesh Wangrungvichaisri
Email address: s...@appsig.com
PostgreSQL version: 8.3.7
Operating system: Windows XP x64 / Windows 7 x64
Description:postgres.exe memory consumption keeps going up
- Examp
The following bug has been logged online:
Bug reference: 4996
Logged by: Shivesh Wangrungvichaisri
Email address: s...@appsig.com
PostgreSQL version: 8.3.7
Operating system: Windows XP x64 / Windows 7 x64
Description:postgres.exe memory consumption keeps going up
Deta
17 matches
Mail list logo
