| From: | 許耀彰 <kpm906(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Fwd: postgresql performance question |
| Date: | 2018-02-11 15:15:24 |
| Message-ID: | CAD_D-c8sVaf40oUMw=N70mkZ904wxgRTFZzjCAW11H8j-ADDkw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| 0101.csv | text/csv | 4.6 MB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Teja | 2018-02-11 16:14:20 | Re: Fwd: postgresql performance question |
| Previous Message | Pavel Stehule | 2018-02-11 11:27:54 | Re: postgresql data transfer from 9.3 to 9.4 |