pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres 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