Jason McLaurin <jason@jcore.io> writes:
> 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 don't
> appear to be queries that would consume a lot of resources.
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.
regards, tom lane