From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: crash with latest git HEAD |
Date: | 2014-04-21 02:41:13 |
Message-ID: | 16151.1398048073@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> writes:
> The following query results in a crash, ultimately due to the process
> running out of memory:
> create table blah as select md5(generate_series(1,50000000)::text) as a;
The behavior looks the same to me in either 9.3 or HEAD: it does consume a
lotta memory (about 7GB) but eventually finishes. If it's crashing for
you, you probably need to look at your system-level configuration,
particularly the per-process memory ulimit level vs. available RAM/swap
and whether the dreaded OOM killer is enabled.
The reason it's eating so much memory is you've got a profligate SRF in
the SELECT's targetlist. Try it as, eg,
create table blah as select md5(g::text) as a from generate_series(1,50000000) g;
While it's be nice to not have SRFs in the targetlist be a memory problem,
it's not an easy thing to do, and I doubt anyone is going to look very
hard for a fix for what is basically a deprecated feature.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | hesam | 2014-04-21 03:13:55 | BUG #10089: apt-get update cannot fine the deb info of postgres |
Previous Message | Jon Nelson | 2014-04-21 02:09:12 | crash with latest git HEAD |