Search Postgresql Archives

Re: Very slow queries followed by checkpointer process killed with signal 9

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux