Re: Searching in varchar column having 100M records

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Searching in varchar column having 100M records
Date: 2019-07-18 22:03:57
Message-ID: 47ae5daa-2e3f-2f15-4511-126dac161ff4@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2019-07-18 22:23:21 Re: Perplexing, regular decline in performance
Previous Message Hugh Ranalli 2019-07-18 20:01:46 Re: Perplexing, regular decline in performance