You probably should upgrade to 7.1.2. I think alot of
memory leaking conditions were fixed between 7.0 and 7.1.
On Wed, 6 Jun 2001, george young wrote:
> [Postgresql 7.0.3, intel Linux, 4 cpu, 2 GB RAM ]
>
> create table stepparams(step_proc text, name text, txt text, units text, step_ver int2, width int2,
> xpos int2, param_edit int2, xlevel int2, mandatory int2, primary key(step_proc));
>
> The table stepparams has 15799 rows, 387 distinct values of step_proc.
>
> For each value stepparams.step_proc e.g. 'foo', there should be a postgres table named "s_foo".
> I want to check this for consistancy, i.e. find any stepparams.step_proc that does not have a corresponding table.
>
> I thought this was a straight forward query:
> select distinct step_proc
> from stepparams sp
> where not exists (select * from pg_class where text(relname)= 's_' || sp.step_proc);
> but, after a while I get an error: FATAL 1: Memory exhausted in AllocSetAlloc()
> pqReadData() -- backend closed the channel unexpectedly.
> [indeed the backend had grown to 400MB, 173MB resident!]