| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Robert Pang <robertpang(at)google(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, robertmhaas(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Back-patch of: avoid multiple hard links to same WAL file after a crash |
| Date: | 2025-04-26 23:03:15 |
| Message-ID: | 20250426230315.35.nmisch@google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Apr 25, 2025 at 03:35:06PM -0400, Andres Freund wrote:
> On 2025-04-20 14:53:39 -0700, Noah Misch wrote:
> > The checkpoints and WAL creation took 30s, but archiving was only 20% done
> > (based on file name 00000001000000000000006D) at the 360s PGCTLTIMEOUT.
>
> Huh. That seems surprisingly slow, even for valgrind. I guess it's one more
> example for why the single-threaded archiving approach sucks so badly :)
Yes! I also didn't expect that v14/v13 would run much faster.
> I just changed the config to --trace-children=no. There already is a valgrind
> run in progress, so it won't be in effect for the next run.
Works for me. I see that resolved things.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2025-04-26 23:55:13 | Re: Get rid of integer divide in FAST_PATH_REL_GROUP() macro |
| Previous Message | Tomas Vondra | 2025-04-26 21:07:46 | Re: pgsql: Add function to get memory context stats for processes |