Andres Freund <andres@anarazel.de> writes:
> It's not surprising that pg_dump takes 30s on that old a machine. But more than 2min still surprised me. Is that
reallydo be expected?
In the previous buildfarm run, that dump took just under 31s:
2022-01-31 14:21:10.358 EST [19325:1] [unknown] LOG: connection received: host=[local]
2022-01-31 14:21:10.367 EST [19325:2] [unknown] LOG: connection authorized: user=buildfarm database=regression
application_name=027_stream_regress.pl
...
2022-01-31 14:21:41.139 EST [19325:2663] 027_stream_regress.pl LOG: disconnection: session time: 0:00:30.782
user=buildfarmdatabase=regression host=[local]
In the failing run, we have:
2022-02-01 04:48:37.757 EST [3683:1] [unknown] LOG: connection received: host=[local]
2022-02-01 04:48:37.767 EST [3683:2] [unknown] LOG: connection authorized: user=buildfarm database=regression
application_name=027_stream_regress.pl
...
2022-02-01 04:49:09.719 EST [3683:2584] 027_stream_regress.pl LOG: statement: COPY public.tenk1 (unique1, unique2,
two,four, ten, twenty, hundred, thousand, twothousand, fivethous, tenthous, odd, even, stringu1, stringu2, string4) TO
stdout;
2022-02-01 04:49:09.881 EST [3683:2585] 027_stream_regress.pl ERROR: canceling statement due to conflict with recovery
2022-02-01 04:49:09.881 EST [3683:2586] 027_stream_regress.pl DETAIL: User query might have needed to see row versions
thatmust be removed.
2022-02-01 04:49:09.881 EST [3683:2587] 027_stream_regress.pl STATEMENT: COPY public.tenk1 (unique1, unique2, two,
four,ten, twenty, hundred, thousand, twothousand, fivethous, tenthous, odd, even, stringu1, stringu2, string4) TO
stdout;
2022-02-01 04:49:09.889 EST [3685:1] [unknown] LOG: connection received: host=[local]
2022-02-01 04:49:09.905 EST [3683:2588] 027_stream_regress.pl LOG: could not send data to client: Broken pipe
2022-02-01 04:49:09.905 EST [3683:2589] 027_stream_regress.pl ERROR: canceling statement due to conflict with recovery
2022-02-01 04:49:09.905 EST [3683:2590] 027_stream_regress.pl DETAIL: User query might have needed to see row versions
thatmust be removed.
2022-02-01 04:49:09.906 EST [3683:2591] 027_stream_regress.pl FATAL: connection to client lost
2022-02-01 04:49:09.935 EST [3683:2592] 027_stream_regress.pl LOG: disconnection: session time: 0:00:32.179
user=buildfarmdatabase=regression host=[local]
That's only a little over 30s. Where are you getting 2m from?
regards, tom lane