| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Christophe Pettus <xof(at)thebuild(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: startup process stuck in recovery |
| Date: | 2017-10-10 14:32:41 |
| Message-ID: | 20171010143241.xep7ppoymhffy2mc@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Christophe Pettus <xof(at)thebuild(dot)com> writes:
> > The problem indeed appear to be a very large number of subtransactions, each one creating a temp table, inside a single transaction. It's made worse by one of those transactions finally getting replayed on the secondary, only to have another one come in right behind it...
>
> Hmm, I tried to reproduce this and could not. I experimented with
> various permutations of this:
This problem is probably related to commit 9b013dc238c, which AFAICS is
only in pg10, not 9.5.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Nicolici | 2017-10-10 14:34:52 | Re: Strange checkpoint behavior - checkpoints take alongtime |
| Previous Message | Vladimir Nicolici | 2017-10-10 14:30:33 | Re: Strange checkpoint behavior - checkpoints take a longtime |