Skip to content
Snippets Groups Projects
  1. Sep 07, 2007
  2. Sep 05, 2007
    • Bruce Momjian's avatar
      Done: · 190df8a4
      Bruce Momjian authored
      < * Reduce XID consumption of read-only queries
      <
      <    http://archives.postgresql.org/pgsql-hackers/2007-08/msg00516.php
      <
      <
      > * -Reduce XID consumption of read-only queries
      190df8a4
    • Tom Lane's avatar
      Implement lazy XID allocation: transactions that do not modify any database · 295e6398
      Tom Lane authored
      rows will normally never obtain an XID at all.  We already did things this way
      for subtransactions, but this patch extends the concept to top-level
      transactions.  In applications where there are lots of short read-only
      transactions, this should improve performance noticeably; not so much from
      removal of the actual XID-assignments, as from reduction of overhead that's
      driven by the rate of XID consumption.  We add a concept of a "virtual
      transaction ID" so that active transactions can be uniquely identified even
      if they don't have a regular XID.  This is a much lighter-weight concept:
      uniqueness of VXIDs is only guaranteed over the short term, and no on-disk
      record is made about them.
      
      Florian Pflug, with some editorialization by Tom.
      295e6398
  3. Sep 04, 2007
  4. Sep 03, 2007
  5. Sep 02, 2007
  6. Aug 31, 2007
  7. Aug 30, 2007
  8. Aug 29, 2007
  9. Aug 28, 2007
  10. Aug 25, 2007
  11. Aug 23, 2007
  12. Aug 22, 2007
Loading