Postgres Pro
Downloads
Home   >   mailing lists

Fwd: postgresql performance question - Mailing list pgsql-bugs

From 許耀彰
Subject Fwd: postgresql performance question
Date
Msg-id CAD_D-c8sVaf40oUMw=N70mkZ904wxgRTFZzjCAW11H8j-ADDkw@mail.gmail.com
Whole thread Raw
Responses Re: Fwd: postgresql performance question  (Pavan Teja <pavan.postgresdba@gmail.com>)
Re: Fwd: postgresql performance question  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Tree view
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


Attachment

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: postgresql data transfer from 9.3 to 9.4
Next
From: Pavan Teja
Date:
Subject: Re: Fwd: postgresql performance question