New answers tagged

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 ...
user avatar
  • 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 ...
user avatar
-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.
user avatar
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 ...
user avatar
  • 1,865

Top 50 recent answers are included