Also there is an issue of the query that FA uses to get the results from PSQL. So there is limit of ~32k even if elastic search is not the limiting factor. https://stackoverflow.com/questions/1009706/postgresql-max-number-of-parameters-in-in-clause.
Best posts made by chakshu
This user hasn't posted anything yet.
Latest posts made by chakshu
RE: Search Limitations and Bypassing them.
Search Limitations and Bypassing them.
I am trying to get all the phone numbers of users for a group, to send them notifications. The number of users are in the range of 1-2 Million. I have a couple of questions,
- Is FA the best place to have such time of queries or should I create a pipeline and publish updates elsewhere?
- Is there an API planned which can allow me to get users data with specific fields - name, phone number or just the data field?
- Is it advisable to modify elastic search to index only certain properties and get results directly from there without fetching the database - Bypassing FA APIs? (I have updated the index.max_result_window to the number of results that I am expecting). Is there is way to make those queries through FA?