strange memory-consumming psql ...

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-interfaces(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: strange memory-consumming psql ...
Date: 2000-12-05 16:04:03
Message-ID: 20001205170403.A11400@gruby
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

just a moment ago friend sent me strange log.
it is partial output of ps auxww on linux system:
---
root 1308 0.0 0.1 4744 248 ? S Nov29 0:01 /usr/lib/postfix/master
postgres 8095 0.0 0.6 7816 784 pts/21 S Nov30 2:07 /usr/bin/postmaster -i -D /var/lib/pgsql -o -Q
postgres 29739 0.2 2.4 7392 3152 pts/21 S Dec03 5:14 /usr/bin/postgres localhost agaran test001 idle
agaran 25448 0.0 0.7 1984 992 pts/14 S 16:51 0:00 grep -i post
agaran 27789 0.0 58.8 77392 74416 pts/13 S Dec03 1:00 psql
---

as you can see the psql process is >77 megabytes !
actually this process was nto doing anything - jsut waiting for another query.
it looks like it was caching some query results or something like that.
i don't know what was the queries run on the psql, but ... it just looks werid.

any ideas on what could have been wrong?

depesz

--
hubert depesz lubaczewski
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...

Browse pgsql-general by date

  From Date Subject
Next Message Adam Lang 2000-12-05 16:39:35 Article involving Postgresql
Previous Message Adam Lang 2000-12-05 15:48:13 Re: Why PostgreSQL is not that popular as MySQL?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Joel Burton 2000-12-05 17:14:37 Re: PostgreSQL ODBC driver: recordset not updatable
Previous Message sschembri 2000-12-05 15:49:58 StarOffice 5.2 for Linux and ODBC