Re: Searching in varchar column having 100M records
Gavin Flower <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Organization | ArchiDevSys |
| Message-ID | <[email protected]> |
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 /