Cc: Thomas Kellerer ; pgsql-general@lists.postgresql.org
> Subject: Re: [EXT] DBeaver session populating pg_stat_activity.backend_xmin
> > On Jan 25, 2023, at 14:21, Dirschel, Steve
> > wrote:
> > From my perspective "idle in transaction" isn't necessarily a pr
> On Jan 25, 2023, at 14:21, Dirschel, Steve
> wrote:
> From my perspective "idle in transaction" isn't necessarily a problem
> (although I don't like seeing sessions sitting like that for a long time).
> The problem is when pg_stat_activity.backend_xmin
On 1/25/23 16:21, Dirschel, Steve wrote:
[snip]
The problem is users will connect using DBeaver and their sessions
will sit idle.
Idle is not a problem, "idle in transaction" is.
From my perspective "idle in transaction" isn't necessarily a problem
(although I don't like seeing sessions sitti
ough I don't like seeing sessions sitting like that for a long time).
>The problem is when pg_stat_activity.backend_xmin is populated- that can
>prevent autovacuum from cleaning up old records. Again, if I login to psql,
>set auto commit off and run a select I see pg_stat_activity.x
Dirschel, Steve schrieb am 25.01.2023 um 20:36:
When I connect to the database through DBeaver with those 2 default
settings changed and find that session in pg_stat_activity column
xact_start is populated along with backend_xmin. Those get
populated just by logging in.
As you found out in the
Not sure if anyone on this list may have ideas on this or not. I will also try
and find a DBeaver e-mail list and send to that also.
We are running into a problem where users will connect to a database through
DBeaver. I have found if I leave all DBeaver options as default this issue
does not
On Wed, 2022-09-21 at 16:22 +, Dirschel, Steve wrote:
> > > > > We are troubleshooting an issue where autovacuum is not cleaning up a
> > > > > table.
> > > > > The application using this database runs with autocommit turned off.
> > > > > We can see in pg_stat_activity lots of sessions “idle
>> On Sep 21, 2022, at 9:32 AM, Dirschel, Steve
>> wrote:
>>
>> On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
We are troubleshooting an issue where autovacuum is not cleaning up a
table.
The application using this database runs with autocommit turned off.
We can
> On Sep 21, 2022, at 9:32 AM, Dirschel, Steve
> wrote:
>
> On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
>>> We are troubleshooting an issue where autovacuum is not cleaning up a table.
>>> The application using this database runs with autocommit turned off.
>>> We can see in pg_
On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
>> We are troubleshooting an issue where autovacuum is not cleaning up a table.
>> The application using this database runs with autocommit turned off.
>> We can see in pg_stat_activity lots of sessions “idle in transaction”
>> even though
On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
> We are troubleshooting an issue where autovacuum is not cleaning up a table.
> The application using this database runs with autocommit turned off.
> We can see in pg_stat_activity lots of sessions “idle in transaction” even
> though those
ersions cannot be removed yet, oldest xmin: 32708199
There were 0 unused item identifiers.
Skipped 0 pages due to buffer pins, 0 frozen pages.
0 pages are entirely empty.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
VACUUM
The xmin value of 32708199 is the value in pg_stat_activity.backend_xm
12 matches
Mail list logo
