Postgres Pro
Downloads
Home   >   mailing lists

Re: Searching in varchar column having 100M records - Mailing list pgsql-performance

From David G. Johnston
Subject Re: Searching in varchar column having 100M records
Date
Msg-id CAKFQuwZ9CnUXB8O+yyOPiEkS5DBDcMPy-Ag1MxmRP2XjYDpTTA@mail.gmail.com
Whole thread Raw
In response to Searching in varchar column having 100M records  (mayank rupareliya <mayankjr03@gmail.com>)
List pgsql-performance
Tree view
On Wed, Jul 17, 2019 at 4:04 AM mayank rupareliya <mayankjr03@gmail.com> wrote:
create table fields(user_id varchar(64), field varchar(64));
CREATE INDEX index_field ON public.fields USING btree (field);

Any suggestions for improvement?

Reduce the number of rows by constructing a relationally normalized data model.

David J.

pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Searching in varchar column having 100M records
Next
From: Hugh Ranalli
Date:
Subject: Re: Perplexing, regular decline in performance