On Tue, Nov 21, 2017 at 03:45:58PM -0800, Andres Freund wrote:
> On 2017-11-21 18:21:16 -0500, Tom Lane wrote:
> > Justin Pryzby <pryzby@telsasoft.com> writes:
> > > As $subject: backends are stuck in startup for minutes at a time. I didn't
> > > strace this time, but I believe last time I saw one was waiting in a futex.
>
> A futex? Hm, that was stock postgres?
Yes, from PGDG:
[pryzbyj@TS-DB ~]$ rpm -q postgresql10
postgresql10-10.1-1PGDG.rhel6.x86_64
> How many different databases and roles are you having on that system?
postgres=# SELECT COUNT(1) FROM pg_roles ;
count | 25
postgres=# SELECT COUNT(1) FROM pg_database;
count | 15
> I guess iiiiiii is a sanitized name?
Yes
> Right. I took this to be referring to something before the current
> migration, but I might have overinterpreted things.
We never had any issue during the ~2 years running PG96 on this VM, until
upgrading Monday to PG10.1, and we've now hit it 5+ times.
BTW this is a VM run on a hypervisor managed by our customer:
DMI: VMware, Inc. VMware Virtual Platform/440BX Desktop Reference Platform, BIOS 6.00 06/22/2012
Linux TS-DB 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
Justin