Re: Problem with insert into select...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with insert into select...
Дата
Msg-id 7439.1069369120@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with insert into select...  (stephen farrell <sfarrell@almaden.ibm.com>)
Ответы Re: Problem with insert into select...  (stephen farrell <sfarrell@almaden.ibm.com>)
Список pgsql-performance
stephen farrell <sfarrell@almaden.ibm.com> writes:
> I'm having a problem with a queyr like:  INSERT INTO FACT (x,x,x,x,x,x)
> SELECT a.key,b.key,c.key,d.key,e.key,f.key from x,a,b,c,d,e,f where x=a
> and x=b ....   -- postgres7.4 is running out of memory.  I'm not sure
> why this would happen -- does it buffer the subselect before doing the
> insert?

What does EXPLAIN show for the query?  And we need to see the exact
query and table definitions, not abstractions.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: stephen farrell
Дата:
Сообщение: Problem with insert into select...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: duration logging setting in 7.4