And then use command as listed as below to import data to log2 table
COPY log2 FROM '/home/anderson/0107.csv' CSV HEADER;
My purpose is to import log information to log2 table to analysis, but I found one situation : for example , I have 166856 records in log2 table, when I use select command to list data , it spent a lot time, can we adjust the situation ?
select * from log2
Thanks for your kindly assistance.
Additional information: The attachment is log format