Postgres Pro
Downloads
Home   >   mailing lists

how to make duplicate finding query faster? - Mailing list pgsql-admin

From Sachin Kumar
Subject how to make duplicate finding query faster?
Date
Msg-id CALg-PKBPQPBMbNAxf-pF0OLbYs0exC7Vf2Sn3hNPUAJ7Q=mPtA@mail.gmail.com
Whole thread Raw
Responses Re: how to make duplicate finding query faster?  (Holger Jakobs <holger@jakobs.com>)
Re: how to make duplicate finding query faster?  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
Hi All,

I am uploading data into PostgreSQL using the CSV file and checking if there is any duplicates value in DB it should return a duplicate error.  I am using below mention query.

if Card_Bank.objects.filter( Q(ACCOUNT_NUMBER=card_number) ).exists():
        flag=2
      else:
        flag=1
it is taking too much time i am using 600k cards in CSV.

Kindly help me in making the query faster.

I am using Python, Django & PostgreSQL.
--

Best Regards,
Sachin Kumar

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patroni issue
Next
From: Holger Jakobs
Date:
Subject: Re: how to make duplicate finding query faster?