Kurt Overberg <kurt(at)hotdogrecords(dot)com> writes:
> delete from xrefmembergroup where membergroupid = 2 ; select 1 as true;
> insert into xrefmembergroup (membergroupid, memberid) select 2 as
> membergroupid, member.id as memberid from member where ((extract(year
> from age(birthdate))) >= '17' ); select 1 as true;
> ...my memory usage goes nuts- allocates 20-30 Mb per time I run this.
Postgres version?
Sounds like a memory leak, but there's not enough info here to debug it.
Which of these queries exactly is leaking memory? If it's the
INSERT/SELECT (as I suspect), what's the schema of the 'member' table?
regards, tom lane