on index_field (cost=0.00..1369.46
rows=52386 width=0) (actual time=125.078..125.079 rows=31857 loops=1)
Index Cond: ((field)::text = 'Champlin'::text)
Planning Time: 8.595 ms
Execution Time: 65093.508 ms
On Thu, Jul 18, 2019 at 6:11 PM Tomas Vondra
wrote:
> On Thu, J
s and result improved but not much.
Thanks Andreas, David, Gavin
*Any particular reason for using varchar instead of text, for field?* No
use UUID for the user_id. Agreed
*Regards,Mayank*
On Thu, Jul 18, 2019 at 4:25 AM Gavin Flower
wrote:
> On 17/07/2019 23:03, mayank rupareliya wrote:
My table is having data like below with 100M records (contains all dummy
data). I am having btree index on column ("field").
*While searching for any text from that column takes longer (more than 1
minute).*
user Id field
d848f466-5e12-46e7-acf4-e12aff592241 Northern Arkansas College
24c32757-e6a8
