Re: Searching in varchar column having 100M records

[Gavin Flower]

On 17/07/2019 23:03, mayank rupareliya wrote:
[...]

Table and index are created using following query.

create table fields(user_id varchar(64), field varchar(64));
CREATE INDEX index_field ON public.fields USING btree (field);

[...]

Any particular reason for using varchar instead of text, for field?

Also, as Andreas pointed out, use UUID for the user_id.


Cheers,
Gavin