| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | aditya desai <admad123(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Fwd: Query out of memory |
| Date: | 2021-10-19 10:26:13 |
| Message-ID: | 20211019102613.GJ4679@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | aditya desai | 2021-10-19 10:46:46 | Re: Query out of memory |
| Previous Message | Dave Cramer | 2021-10-19 09:57:37 | Re: Query out of memory |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | aditya desai | 2021-10-19 10:46:46 | Re: Query out of memory |
| Previous Message | Dave Cramer | 2021-10-19 09:57:37 | Re: Query out of memory |