INSERT does not finish except if it is carried out a few minutes after the creation of the table

Поиск
Список
Период
Сортировка
От Matthieu Guamis
Тема INSERT does not finish except if it is carried out a few minutes after the creation of the table
Дата
Msg-id 4506A384.4000900@axege.com
обсуждение исходный текст
Ответы Re: INSERT does not finish except if it is carried out a few minutes after the creation of the table  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-novice
hi all,

During the execution of the following requests, INSERT does not finish
except if it is carried out a few minutes after the
creation of the table. How to explain this latency time?

CREATE produces a table with the number of events of a product (id1)
for a customer (id2) having attribute “ABCD”.
INSERT adds a row for each product a client did not buy whereas others
of group "ABCD" did. That is done by selecting the
Cartesian product between the attributes id1 and id2 then removing
(EXCEPT) lines whose couple (id1, id2) is already in…

-----------------------------------------
drop table maTable;

create table maTable as (
select id1,id2,count(*)
from table1
where cle = 'ABCD'
group by id1, id2
order by id2,id1);

insert into maTable (select * from
((select a.id1 ,b.id2 ,0
from maTable a, maTable b
group by a.id1,b.id2
order by b.id2,a.id1)
EXCEPT
(select c.id1 ,c.id2 ,0
from maTable c
))as tt;
-----------------------------------------

DROP and CREATE do their job but INSERT does not finish if it is
carried out immediately after the CREATE. On the other hand

if it is carried out a few minutes (~5min) later then INSERT commits in
a few seconds.

Rq: If drop/create/insert is replaced by delete/insert/insert then it's
ok.
Finally the creation of a “Temporary” table leads to the same
problem.   

Thank you for your assistance,

Mat

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

Предыдущее
От: pr0v4
Дата:
Сообщение: Passing arguments
Следующее
От: "Sree Narayana"
Дата:
Сообщение: Problme in my pg_dump command