Re: [HACKERS] INSERT INTO ... SELECT eats all my memory

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: Daniele Orlandi <daniele(at)orlandi(dot)com>, hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] INSERT INTO ... SELECT eats all my memory
Date: 1999-05-10 16:39:22
Message-ID: 37370BBA.A58928B5@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
>
> Do we have a problem here? Can someone explain it? Is it the
> conversion of the types?
>
> >
> > insert into log select username, server, pop, remaddr, port, service, NULL,
> > privilege, authenmethod, authentype, authenservice, logtime, starttime,
> > elapsedtime, bytesin, bytesout, paksin, paksout, callerid, callednumber, NULL,
> > NULL, NULL, NULL, NULL, NULL from log2;

EXPLAIN VERBOSE _query_above_

?

Vadim

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-05-10 16:40:40 Re: [HACKERS] Help/advice/suggestions on query optimizer for a large table
Previous Message Jan Wieck 1999-05-10 16:39:08 Re: [HACKERS] create view as select distinct (fwd)