From: | aditya desai <admad123(at)gmail(dot)com> |
---|---|
To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Query out of memory |
Date: | 2021-10-19 10:46:46 |
Message-ID: | CAN0SRDESW-3HbuBDm6nyNceXKjRt0kQcVHi4veokWe-9naeFWA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance pgsql-sql |
Hi Justin,
Out of memory on pgadmin and psql. I executed it with explain analyze.
Still going out of memory.
Also currently 250 user connections are not being made. There are hardly
10 connections to database. When I run thi query it is going out of memory.
Also this query is part of a view that gets referred in a
procedure.Transaction table is partitioned table but due to business
requirements partition key is not part of where clause.
Regards,
Aditya.
On Tuesday, October 19, 2021, Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> 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 | Andreas Joseph Krogh | 2021-10-19 11:08:03 | Sv: Fwd: Query out of memory |
Previous Message | Justin Pryzby | 2021-10-19 10:26:13 | Re: Fwd: Query out of memory |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2021-10-19 11:08:03 | Sv: Fwd: Query out of memory |
Previous Message | Justin Pryzby | 2021-10-19 10:26:13 | Re: Fwd: Query out of memory |