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

2023-04-02 Thread Jason McLaurin
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 thre

Very slow queries followed by checkpointer process killed with signal 9

2023-04-02 Thread Jason McLaurin
Hello, I'm troubleshooting an issue where about once a week, a database appears to lock up and then the PostgreSQL process crashes and recovers. When this happens, a few queries will be logged, but there is no pattern to which queries are executing when the crash happens, and the queries logged do