Re: Very slow queries followed by checkpointer process killed with signal 9 - Mailing list pgsql-general

From Jason McLaurin
Subject Re: Very slow queries followed by checkpointer process killed with signal 9
Date
Msg-id CAJN0UCSqDfQpS-xsiMj4BdSUOS0iyFWo8-Xs+4UN-GFY8ucnZQ@mail.gmail.com
Whole thread Raw
In response to Re: Very slow queries followed by checkpointer process killed with signal 9  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Very slow queries followed by checkpointer process killed with signal 9
List pgsql-general
Hi Tom,


Hmm, is it always the checkpointer that gets the OOM kill?  That seems
quite odd.

What PG version is this exactly?  Do you have any extensions installed?

I recall having seen somebody before reporting odd slowness of trivial
commands like BEGIN.  I failed to find the thread(s) in the archives
though, so I'm not sure if we identified the cause.


This is Postgres 14.5 running in the TimescaleDB Docker image. We're not actually using TimescaleDB on this database instance (there are no hypertables), but we use the same Docker image everywhere. So it's certainly possible that a TimescaleDB background process is to blame despite the complete lack of TimescaleDB-enabled tables.

Is there anywhere you'd suggest we start looking for hints? I'd be interested in increasing relevant logging verbosity so that we can see when key background processes are running, both in Postgres core and Timescale.

Thanks so much!
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: What permissions are needed to drop a column from a table in postgres?
Next
From: Tom Lane
Date:
Subject: Re: Very slow queries followed by checkpointer process killed with signal 9