[HN Gopher] When Postgres blocks: tips for dealing with locks
___________________________________________________________________
 
When Postgres blocks: tips for dealing with locks
 
Author : saisrirampur
Score  : 9 points
Date   : 2022-02-12 21:25 UTC (1 hours ago)
 

web link (www.citusdata.com)

w3m dump (www.citusdata.com)

 
| hyzyla wrote:
| Statement about default value for new column is not actual
| anymore starting from Postgres 11
| 
| https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-...
 
  | saisrirampur wrote:
  | That is right.. default value for new column is now pretty
  | fast.. all the other 6 tips are current and very relevant..
  | this blog has been my goto blog for debugging locks in
  | postgres, as it captures a very crisp summary on this topic!
 
___________________________________________________________________
(page generated 2022-02-12 23:00 UTC)