Re: Fwd: postgresql performance question - Mailing list pgsql-bugs

Dear Support Team, 

I create a table by command as listed as below:

CREATE TABLE public.log2

(

        d3 text COLLATE pg_catalog."default"

)

WITH (

    OIDS = FALSE

)

TABLESPACE pg_default;

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

Best Regards, Anderson Hsu