Thanks David for the nice suggestion.
Text search would not my requirement. Because user wants to provide condition similar to where clause.
I thought let postgres query the data based on only time column. That result would be stored in cursor and fetch 5000 sequentially when the user ask. Once after the result is received by UI, let UI do the complete query processing.
I am not sure about this idea, but is that possible I can apply where clause on cursor result (in 5000 batch)?
Thanks & Regards,
Ramkumar.
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Wednesday, June 10, 2015 1:48 AM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] user constructed where clause
Now, the requirement is if user provides filter information based on every column from the web UI, this filter will let the user construct the “where clause” and provide to postgresql.
In a month this table exceeds millions of record. If I use the user-constructed query then it would take lot of time as the user may not include indexed column in the user-constructed query.
The first solution that comes to mind is to construct a document containing the relevant information, index that, and then provide a single search input field that is used to construct a text search query that you apply against the indexed document.
In short, forget the fact that there are fields and just index and search the content.
Add additional controls to the UI for just those fields that are indexed.