| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> |
| Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: DB running out of memory issues after upgrade |
| Date: | 2020-02-24 16:34:03 |
| Message-ID: | CAHyXU0ziac57C5_TLr_MF+pFWAgKq=KbvUQuzUgiHk-zNt-OKg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers pgadmin-support pgsql-admin pgsql-bugs pgsql-general pgsql-hackers pgsql-performance pgsql-pkg-yum |
On Tue, Feb 18, 2020 at 1:10 PM Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> wrote:
>
> Hi Merlin,
>
> Its configured high value for max_conn, but active and idle session have never crossed the count 50.
>
> DB Size: 20 GB
> Table size: 30MB
> RAM: 16GB
> vC: 4
>
>
> yes, its view earlier I posted and here is there query planner for new actual view,
>
> "Append (cost=0.00..47979735.57 rows=3194327000 width=288)"
> " -> Seq Scan on msghist (cost=0.00..15847101.30 rows=3162700000 width=288)"
> " -> Seq Scan on msghist msghist_1 (cost=0.00..189364.27 rows=31627000 width=288)"
Database size of 20GB is not believable; you have table with 3Bil
rows, this ought to be 60GB+ mill+ all by itself. How did you get
20GB figure?
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pradip Parkale | 2020-02-25 10:02:03 | Re: [pgAdmin][RM5154] [Accessibility] : Alertify |
| Previous Message | Dave Page | 2020-02-24 15:35:37 | pgAdmin 4 commit: Fix the docker build. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathieu Jobin | 2020-03-04 01:11:59 | shared password into the admin |
| Previous Message | Dave Page | 2020-02-24 09:23:43 | Re: Privacy question regarding the "Geometry Viewer" feature in pgAdmin 4. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bricklen | 2020-02-24 17:15:49 | Re: benchmarking proposed config |
| Previous Message | Tom Lane | 2020-02-24 14:50:53 | Re: PG v12.2 - Setting jit_above_cost is causing the server to crash |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan José Santamaría Flecha | 2020-02-24 17:56:05 | Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform |
| Previous Message | Tom Lane | 2020-02-24 15:04:06 | Re: BUG #16274: Repeated Libraries in Mac |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2020-02-24 17:54:53 | Re: Reset DB stats suggestion pg_stat_reset() |
| Previous Message | bvo | 2020-02-24 15:50:34 | Re: backup broken |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2020-02-24 16:59:28 | Re: pgsql: Allow running src/tools/msvc/mkvcbuild.pl under not Windows |
| Previous Message | Peter Eisentraut | 2020-02-24 16:03:07 | Re: client-side fsync() error handling |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Garg | 2020-02-24 19:40:16 | Re: PostgreSQL 11 higher Planning time on Partitioned table |
| Previous Message | Imre Samu | 2020-02-23 16:18:26 | Re: PostgreSQL 11 higher Planning time on Partitioned table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DIZON JEAN (ディゾン ジーン) | 2020-02-27 00:13:37 | RHEL7.4: Failed yum command for PostgreSQL 9.5 |
| Previous Message | Peter J. Holzer | 2020-02-23 10:19:28 | Re: DB running out of memory issues after upgrade |