Re: is pg_stat_activity "transactional"? How fast does it update?

On Tue, Jun 10, 2025 at 5:46 PM Dominique Devienne wrote: > On Tue, Jun 10, 2025 at 4:27 PM Tom Lane wrote: > > PQfinish is asynchronous: [...] > > [...] pg_stat_activity() takes a snapshot of the view's contents > Many thanks Tom. Didn't know either of those facts. Hi. I ended up polling pg_sta

Re: Logical Replication Memory Allocation Error - "invalid memory alloc request size"

Hi Hayato, Thank you for your reply. We have rewritten as many of our transactions as possible to avoid using temporary tables, and so far, that seems to have resolved the problem. Thank you for your help. Many thanks, Max On Wed, Jun 11, 2025 at 3:31 AM Hayato Kuroda (Fujitsu) < kuroda.hay..

Re: pg_upgradecluster version 10 to 16 question

On 6/11/25 12:53, Bruce Momjian wrote: On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote: I configured the PGDG repository and tried to install postgresql-10 on my kubuntu 24.04 LTS desktop system, but apt refused to install it because of unsatisfied dependencies.  I then installed kub

Re: pg_upgradecluster version 10 to 16 question

On 6/11/25 11:59, Jim Cunning wrote: I configured the PGDG repository and tried to install postgresql-10 on my kubuntu 24.04 LTS desktop system, but apt refused to install it because of unsatisfied dependencies.  I then installed kubuntu 22.04 LTS Out of curiosity what where the unsatisfied d

Re: pg_upgradecluster version 10 to 16 question

I have lost the console output of the installation attempt, but I believe there were two unsatisfied dependencies.  One I think was a glibc version mismatch, but I don't recall the version numbers.  I was in a hurry to find an installation solution, so I didn't spend muc

Re: pg_upgradecluster version 10 to 16 question

On 6/11/25 13:07, David G. Johnston wrote: On Wednesday, June 11, 2025, Bruce Momjian > wrote: On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote: > I configured the PGDG repository and tried to install postgresql-10 on my > kubuntu 24.04 LTS d

Re: pg_upgradecluster version 10 to 16 question

I configured the PGDG repository and tried to install postgresql-10 on my kubuntu 24.04 LTS desktop system, but apt refused to install it because of unsatisfied dependencies.  I then installed kubuntu 22.04 LTS on a backup system and was able to install postgresql-10 the

Re: pg_upgradecluster version 10 to 16 question

On Wednesday, June 11, 2025, Bruce Momjian wrote: > On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote: > > I configured the PGDG repository and tried to install postgresql-10 on my > > kubuntu 24.04 LTS desktop system, but apt refused to install it because > of > > unsatisfied dependenc

Re: pg_upgradecluster version 10 to 16 question

On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote: > I configured the PGDG repository and tried to install postgresql-10 on my > kubuntu 24.04 LTS desktop system, but apt refused to install it because of > unsatisfied dependencies.  I then installed kubuntu 22.04 LTS on a backup > system

Re: pg_upgradecluster version 10 to 16 question

On Wed, Jun 11, 2025 at 01:07:11PM -0700, David G. Johnston wrote: > On Wednesday, June 11, 2025, Bruce Momjian wrote: > > On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote: > > I configured the PGDG repository and tried to install postgresql-10 on > my > > kubuntu 24.04 LT

RE: Logical Replication Memory Allocation Error - "invalid memory alloc request size"

Dear Max, > We have rewritten as many of our transactions as possible to avoid using > temporary tables, and so far, that seems to have resolved the problem. Good to know. We try to fix as soon as possible. Sorry for inconvenience. Best regards, Hayato Kuroda FUJITSU LIMITED