Re: [GENERAL] startup process stuck in recovery - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: [GENERAL] startup process stuck in recovery
Date
Msg-id CAH2-Wzk66CmAuDiNrosByNX8+mR0-ca92OC=vxb4ntfUwdJ17g@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] startup process stuck in recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] startup process stuck in recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, Oct 9, 2017 at 5:30 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> and did not see any untoward behavior, at least not till I got to enough
> temp tables to overrun the master's shared lock table, and even then it
> cleaned up fine.  At no point was the standby process consuming anywhere
> near as much CPU as the master's backend.
>
> What am I missing to reproduce the problem?

Just a guess, but do you disable autovacuum on your dev machine? (I know I do.)

It's possible that this is relevant:
https://postgr.es/m/CAB-EU3RawZx8-OzMfvswFf6z+Y7GOZf03TZ=bez+PbQX+A4M7Q@mail.gmail.com

-- 
Peter Geoghegan


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] startup process stuck in recovery
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] startup process stuck in recovery