Re: Searching in varchar column having 100M records

"David G. Johnston" <[email protected]> Wed, 17 Jul 2019 06:57:27 -0700

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<CAKFQuwZ9CnUXB8O+yyOPiEkS5DBDcMPy-Ag1MxmRP2XjYDpTTA@mail.gmail.com>

On Wed, Jul 17, 2019 at 4:04 AM mayank rupareliya <[email protected]>
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.