On Tue, Oct 19, 2021 at 11:28:46AM +0530, aditya desai wrote:
> I am running the below query. Table has 21 million records. I get an Out Of
> Memory error after a while.(from both pgadmin and psql). Can someone review
Is the out of memory error on the client side ?
Then you've simply returned more rows than the client can support.
In that case, you can run it with "explain analyze" to prove that the server
side can run the query. That returns no data rows to the client, but shows the
number of rows which would normally be returned.
--
Justin