1. 08 Jan, 2010 3 commits
    • Tom Lane's avatar
      Fix oversight in EvalPlanQualFetch: after failing to lock a tuple because · 217dc525
      Tom Lane authored
      someone else has just updated it, we have to set priorXmax to that tuple's
      xmax (ie, the XID of the other xact that updated it) before looping back to
      examine the next tuple.  Obviously, the next tuple in the update chain should
      have that XID as its xmin, not the same xmin as the preceding tuple that we
      had been trying to lock.  The mismatch would cause the EvalPlanQual logic to
      decide that the tuple chain ended in a deletion, when actually there was a
      live tuple that should have been found.
      
      I inserted this error when recently adding logic to EvalPlanQual to make it
      lock tuples before returning them (as opposed to the old method in which the
      lock would occur much later, causing a great deal of work to be wasted if we
      only then discover someone else updated it).  Sigh.  Per today's report from
      Takahiro Itagaki of inconsistent results during pgbench runs.
      217dc525
    • Itagaki Takahiro's avatar
    • Itagaki Takahiro's avatar
      Add buffer access counters to pg_stat_statements. · 8964dbd5
      Itagaki Takahiro authored
      This uses the same infrastructure with EXPLAIN BUFFERS to support
      {shared|local}_blks_{hit|read|written} andtemp_blks_{read|written}
      columns in the pg_stat_statements view. The dumped file format
      also updated.
      
      Thanks to Robert Haas for the review.
      8964dbd5
  2. 07 Jan, 2010 14 commits
  3. 06 Jan, 2010 23 commits