/pgpatches/HOT

text/x-diff

Filename: /pgpatches/HOT

Type: text/x-diff

Part: 0

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →

Format: context

File	+	−
src/backend/access/heap/README.HOT	6	0

Index: src/backend/access/heap/README.HOT
===================================================================
RCS file: /cvsroot/pgsql/src/backend/access/heap/README.HOT,v
retrieving revision 1.6
diff -c -c -r1.6 README.HOT
*** src/backend/access/heap/README.HOT	23 Apr 2010 23:21:44 -0000	1.6
--- src/backend/access/heap/README.HOT	17 Sep 2010 19:48:16 -0000
***************
*** 246,251 ****
--- 246,257 ----
  is arbitrarily capped at MaxHeapTuplesPerPage (the most tuples that
  could fit without HOT pruning).
  
+ Effectively, space reclamation happens during tuple retrieval when the
+ page is nearly full (<10%) and a buffer cleanup lock can be acquired. 
+ This means that UPDATE, DELETE, and SELECT can trigger space
+ reclamation, while INSERT ... VALUES cannot because it does not retrieve
+ a row.
+ 
  
  VACUUM
  ------