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

From Gavin Flower
Subject Re: Searching in varchar column having 100M records
Date
Msg-id 47ae5daa-2e3f-2f15-4511-126dac161ff4@archidevsys.co.nz
Whole thread Raw
In response to Re: Searching in varchar column having 100M records  (mayank rupareliya <mayankjr03@gmail.com>)
List pgsql-performance
On 18/07/2019 23:51, mayank rupareliya wrote:
[...]
> Thanks Andreas, David, Gavin
>
> /Any particular reason for using varchar instead of text, for field?/ No
>
> use UUID for the user_id.Agreed

/[...]/

/Use of text is preferred, but I can't see it making any significant 
difference to performance -- but I could be wrong!/

/Cheers,
Gavin
/




pgsql-performance by date:

Previous
From: Hugh Ranalli
Date:
Subject: Re: Perplexing, regular decline in performance
Next
From: Andres Freund
Date:
Subject: Re: Perplexing, regular decline in performance