On 05/24/21 19:24, Christophe Pettus wrote:
On May 24, 2021, at 09:22, Bob Jolliffe wrote:
It is hard to say as it only happens for 30s couple of times per day.
Everything does return to normal after the blocking transaction is
committed. It could be a disk thing or even a network issue (the
> On May 24, 2021, at 09:22, Bob Jolliffe wrote:
>
> It is hard to say as it only happens for 30s couple of times per day.
> Everything does return to normal after the blocking transaction is
> committed. It could be a disk thing or even a network issue (the java
> app is on a different machi
It is hard to say as it only happens for 30s couple of times per day.
Everything does return to normal after the blocking transaction is
committed. It could be a disk thing or even a network issue (the java
app is on a different machine to the db). But I never saw
transactions blocked in commit b
Philip Lykke Carlsen writes:
> My question then is, shouldn't the inner and outer join queries be
> semantically equivalent when the columns we are joining on are
> non-nullable foreign keys?
Maybe, but no such knowledge is built into the planner.
> Is there some corner case I'm not considering?
No worries,
There were some threads earlier which mentioned some automated changes to
disk by the provider that resulted in some slowness.
But otherwise also, do you query system, disk metrics.
Do you see any anomaly in disk io (wait) when you saw blocking?
If it did, did the io return to norma
Hello Jain
Sorry forgot to indicate: it is running the ubuntu packaged version
13.3 on ubuntu 20.04.
It is not in the cloud, but is a VM in a government datacentre. I am
not sure of the underlying hyperviser. I could find out.
Regards
Bob
On Mon, 24 May 2021 at 12:35, Vijaykumar Jain
wrote
Hi list.
I have a question about the different plans produced by postgres for
an outer join versus an inner join.
(complete sql script attached)
Take these two tables:
CREATE TABLE album
( id SERIAL PRIMARY KEY,
title TEXT NOT NULL
);
CREATE INDEX album_title ON albu
I think there have been similar issues reported earlier as well. But it
would be too early to generalize.
Where is the db server running? Cloud?
Also what is the version ?
On Mon, May 24, 2021, 5:00 PM Bob Jolliffe wrote:
> I am seeing a strange issue on a database using jdbc. Regularly, 4
I am seeing a strange issue on a database using jdbc. Regularly, 4 or
5 times a day, I see something like a "stutter", where a bundle of
maybe 30 transactions suddenly finish at the same time. It looks like
(it is quite hard to catch this exactly) that the lead transaction
which has been blockin
