New answers tagged locking
0
votes
Understanding MySQL Locks and Deadlocks
Comparing a VARCHAR to a numeric literal is a pitfall that I sometimes see in SELECT ... WHEREs. You seem to be experiencing the same thing in UPDATE...WHEREs.
The varchar is converted to numeric ...
- 69.5k
2
votes
Accepted
Is it possible to never run vacuum full in PostgreSQL
In order to understand the differences between
VACUUM
VACUUM ANALYZE
VACUUM FULL,
a basic understanding of PostgreSQL's architecture is required.
From several9s1 we are told that:
PostgreSQL does ...
- 27.5k
-1
votes
Is it possible to never run vacuum full in PostgreSQL
For super users, we can't block vacuum full & only vacuum on the table no going to make the space reusable, we have to use vacuum full to physically remove the dead tuple.
- 1
5
votes
Accepted
How an Update on table X can lock table Y?
There are several options, and you must find the link between the tables.
Check for hidden references:
Foreign Keys
Triggers
Scalar UDFs
In Computed columns
In Check constraints
The locks on ...
- 1,865
Top 50 recent answers are included