Skip site navigation (1) Skip section navigation (2)

Postmaster getting veeeery big

From: Eildert Groeneveld <eg(at)tzv(dot)fal(dot)de>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Postmaster getting veeeery big
Date: 1999-05-18 09:05:45
Message-ID: 99051811205503.00540@salo.tzv.fal.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)tzv(dot)fal(dot)de
=========================================

Responses

pgsql-interfaces by date

Next:From: Peter HarveyDate: 1999-05-18 20:24:37
Subject: unixODBC + PostgreSQL + StarOffice 5
Previous:From: Julian ScarfeDate: 1999-05-18 09:01:43
Subject: Re: [INTERFACES] Paths in DBD::Pg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group