S
Делаю explain analyze запроса. Первый проход actual_time~20сек. При повторном чтении уже 4сек.
Каким образом получать план запроса как будто запускаю первый раз?
Size: a a a
S
АА
S
AG
S
D
АА
D
insert into invert01 keyword as doc, doc_id as id FROM docs01;
IA
АА
insert into invert01(doc, id)
select keyword, doc_id FROM docs01;
D
ERROR: column "doc" of relation "invert01" does not exist
LINE 1: insert into invert01(doc, id)
^
D
insert into invert01(keyword, doc_id)
select doc, id FROM docs01;
INSERT 0 10
D
keyword | doc_id
--------------------------------------------------------------------------+--------
skill and art in constructing the story and skill in story writing | 1
is improved by doing some writing and getting some feedback In | 2
programming our program is the story and the problem you are | 3
trying to solve is the idea | 4
Once you learn one programming language such as Python you will find it | 5
much easier to learn a second programming language such as JavaScript or | 6
C The new programming language has very different vocabulary and | 7
grammar but the problemsolving skills will be the same across all | 8
You will learn the vocabulary and sentences of Python pretty | 9
quickly It will take longer for you to be able to write a coherent |
АА
D
D
АА
D
D