Re: Fwd: postgresql performance question

Hi,

You can filter by using error_severity condition in the where Clause like:
Select * from log2 where error_severity ='error';

Regards,
Pavan

On Feb 11, 2018 9:31 PM, "許耀彰" <kpm906(at)gmail(dot)com> wrote:

> 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
>
>
>