From: Eildert Groeneveld <eg@tzv.fal.de>
To: pgsql-interfaces@postgresql.org
Subject: Postmaster getting veeeery big
Date: Tue, 18 May 1999 11:05:45 +0200
Message-ID: <99051811205503.00540@salo.tzv.fal.de> (raw)
Hello everyone,
we observe a problem when doing some sort of aggregation like
select distinct count(substr(narodene,5,4)) from raw_field;
(raw_field has 1300000 rows)
On executing this query the postmaster grows in memory size until it runs
out of virtual mem and dies.
Any ideas of what is going on and how to avoid this?
Eildert Groeneveld
ps. RedHat5.2 postgresql-6.4.2-4
=========================================
Institute for
Animal Science and Animal Behaviour
Mariensee 31535 Neustadt Germany
Tel : (49)(0)5034 871155
Fax : (49)(0)5034 92579
www : http://www.tzv.fal.de/~eg/
e-mail: eg@tzv.fal.de
=========================================
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-interfaces@postgresql.org
Cc: eg@tzv.fal.de
Subject: Re: Postmaster getting veeeery big
In-Reply-To: <99051811205503.00540@salo.tzv.fal.de>
* 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