| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jason McLaurin <jason(at)jcore(dot)io> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Very slow queries followed by checkpointer process killed with signal 9 |
| Date: | 2023-04-02 23:43:42 |
| Message-ID: | 1077329.1680479022@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jason McLaurin <jason(at)jcore(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Siddharth Jain | 2023-04-03 00:05:06 | What permissions are needed to drop a column from a table in postgres? |
| Previous Message | Jason McLaurin | 2023-04-02 22:25:19 | Very slow queries followed by checkpointer process killed with signal 9 |