| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> |
| Cc: | Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Logical replication ApplyContext bloat |
| Date: | 2017-04-19 13:07:38 |
| Message-ID: | 20170419130738.chzp57u4vxmaw5ee@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Stas Kelvich wrote:
> With patch MemoryContextStats() shows following hierarchy during slot operations in
> apply worker:
>
> TopMemoryContext: 83824 total in 5 blocks; 9224 free (8 chunks); 74600 used
> ApplyContext: 8192 total in 1 blocks; 6520 free (4 chunks); 1672 used
> ApplyMessageContext: 8192 total in 1 blocks; 6632 free (11 chunks); 1560 used
> ExecutorState: 8192 total in 1 blocks; 7624 free (0 chunks); 568 used
> ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Please update src/backend/utils/mmgr/README to list the new contexts.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2017-04-19 13:57:58 | Re: Interval for launching the table sync worker |
| Previous Message | Petr Jelinek | 2017-04-19 13:07:23 | Re: Interval for launching the table sync worker |