pg.ddx.io  pgsql-novice@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-novice@postgresql.org
Subject: Re: Linux server connection process consumes all memory
Date: Sat, 3 Dec 2011 15:58:38 -0800
Message-ID: <201112031558.38312.ahodgson@simkin.ca> (raw)
In-Reply-To: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A09@appserver.anatec.local>
References: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A09@appserver.anatec.local>

On Saturday, December 03, 2011 02:45:11 PM Ioannis Anagnostopoulos wrote:
> When I start iterating executing the select command as time goes by the
> memory footprint of the process grows bigger and bigger. Sooner or later
> the server either collapses or becomes unworkable as the physical memory

It's not clear from this what process is continuing to grow. Is it the 
PostgreSQL server process? Or your client process?



view thread (22+ messages)  latest in thread

Message-ID: <201112031558.38312.ahodgson@simkin.ca>
Permalink:  ../201112031558.38312.ahodgson@simkin.ca/
Also on:    postgresql.org/message-id/201112031558.38312.ahodgson@simkin.ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-novice@postgresql.org
  Cc: ahodgson@simkin.ca
  Subject: Re: Linux server connection process consumes all memory
  In-Reply-To: <201112031558.38312.ahodgson@simkin.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox