| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: postgres keeps having blocks |
| Date: | 2023-10-18 14:15:15 |
| Message-ID: | a177f72b-9ecb-41fd-891c-73bef8224971@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/18/23 07:40, David G. Johnston wrote:
> On Wednesday, October 18, 2023, Shaozhong SHI <shishaozhong(at)gmail(dot)com> wrote:
>
> My postgres is playing up.
>
> I terminated session that is causing blocks many time.
>
> New block appears.
>
> Endless.
>
> What should I do?
>
>
> PostgreSQL is probably just doing what you told it. Not possible to give
> advice without knowing what you told it to do. You should put more effort
> into showing others what your app is doing and how you are debugging it
> and the database.
>
> Killing sessions without changing anything else is unlikely to result in a
> change of behavior.
That's the definition of insanity...
--
Born in Arizona, moved to Babylonia.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-10-18 15:56:45 | Re: A few questions about foreign tables |
| Previous Message | Thomas Kellerer | 2023-10-18 12:42:17 | Re: Inheritance in PostgreSQL |