pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres keeps having blocks
5+ messages / 5 participants
[nested] [flat]
* postgres keeps having blocks
@ 2023-10-18 11:27 Shaozhong SHI <shishaozhong@gmail.com>
2023-10-18 12:40 ` Re: postgres keeps having blocks David G. Johnston <david.g.johnston@gmail.com>
2023-10-18 16:15 ` Re: postgres keeps having blocks Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 2 replies; 5+ messages in thread
From: Shaozhong SHI @ 2023-10-18 11:27 UTC (permalink / raw)
To: pgsql-general
My postgres is playing up.
I terminated session that is causing blocks many time.
New block appears.
Endless.
What should I do?
Regards,
David
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres keeps having blocks
2023-10-18 11:27 postgres keeps having blocks Shaozhong SHI <shishaozhong@gmail.com>
@ 2023-10-18 12:40 ` David G. Johnston <david.g.johnston@gmail.com>
2023-10-18 14:15 ` Re: postgres keeps having blocks Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2023-10-18 12:40 UTC (permalink / raw)
To: Shaozhong SHI <shishaozhong@gmail.com>; +Cc: pgsql-general
On Wednesday, October 18, 2023, Shaozhong SHI <shishaozhong@gmail.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.
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres keeps having blocks
2023-10-18 11:27 postgres keeps having blocks Shaozhong SHI <shishaozhong@gmail.com>
2023-10-18 12:40 ` Re: postgres keeps having blocks David G. Johnston <david.g.johnston@gmail.com>
@ 2023-10-18 14:15 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Ron @ 2023-10-18 14:15 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On 10/18/23 07:40, David G. Johnston wrote:
> On Wednesday, October 18, 2023, Shaozhong SHI <shishaozhong@gmail.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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres keeps having blocks
2023-10-18 11:27 postgres keeps having blocks Shaozhong SHI <shishaozhong@gmail.com>
@ 2023-10-18 16:15 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-10-18 17:15 ` Re: postgres keeps having blocks Rob Sargent <robjsargent@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Adrian Klaver @ 2023-10-18 16:15 UTC (permalink / raw)
To: Shaozhong SHI <shishaozhong@gmail.com>; pgsql-general
On 10/18/23 04:27, Shaozhong SHI wrote:
> My postgres is playing up.
>
> I terminated session that is causing blocks many time.
>
> New block appears.
>
> Endless.
>
> What should I do?
Provide more information.
1) Postgres version.
2) Define what blocks means.
3) Show us the statements/code that is causing the issue.
4) Post relevant sections from the Postgres log.
>
> Regards,
>
> David
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres keeps having blocks
2023-10-18 11:27 postgres keeps having blocks Shaozhong SHI <shishaozhong@gmail.com>
2023-10-18 16:15 ` Re: postgres keeps having blocks Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-10-18 17:15 ` Rob Sargent <robjsargent@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Rob Sargent @ 2023-10-18 17:15 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On 10/18/23 10:15, Adrian Klaver wrote:
> On 10/18/23 04:27, Shaozhong SHI wrote:
>> My postgres is playing up.
>>
>> I terminated session that is causing blocks many time.
>>
>> New block appears.
>>
>> Endless.
>>
>> What should I do?
>
> Provide more information.
>
> 1) Postgres version.
>
> 2) Define what blocks means.
>
> 3) Show us the statements/code that is causing the issue.
>
> 4) Post relevant sections from the Postgres log.
>
>
Commit your transactions?
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-10-18 17:15 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-18 11:27 postgres keeps having blocks Shaozhong SHI <shishaozhong@gmail.com>
2023-10-18 12:40 ` David G. Johnston <david.g.johnston@gmail.com>
2023-10-18 14:15 ` Ron <ronljohnsonjr@gmail.com>
2023-10-18 16:15 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-10-18 17:15 ` Rob Sargent <robjsargent@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox