Skip to content
Snippets Groups Projects
  1. May 25, 2004
  2. May 24, 2004
  3. May 23, 2004
    • Tom Lane's avatar
      New two-stage sampling method for ANALYZE, as per discussions a few weeks · 9d6570b8
      Tom Lane authored
      ago.  This should give significantly better results when the density of
      live tuples is not uniform throughout a table.  Manfred Koizar, with
      minor kibitzing from Tom Lane.
      9d6570b8
    • Tom Lane's avatar
      Still another place to make the world safe for zero-column tables: · 27edff70
      Tom Lane authored
      remove the ancient (and always pretty dodgy) assumption in parse_clause.c
      that a query can't have an empty targetlist.
      27edff70
    • Tom Lane's avatar
    • Tom Lane's avatar
      Handle impending sinval queue overflow by means of a separate signal · ebfc56d3
      Tom Lane authored
      (SIGUSR1, which we have not been using recently) instead of piggybacking
      on SIGUSR2-driven NOTIFY processing.  This has several good results:
      the processing needed to drain the sinval queue is a lot less than the
      processing needed to answer a NOTIFY; there's less contention since we
      don't have a bunch of backends all trying to acquire exclusive lock on
      pg_listener; backends that are sitting inside a transaction block can
      still drain the queue, whereas NOTIFY processing can't run if there's
      an open transaction block.  (This last is a fairly serious issue that
      I don't think we ever recognized before --- with clients like JDBC that
      tend to sit with open transaction blocks, the sinval queue draining
      mechanism never really worked as intended, probably resulting in a lot
      of useless cache-reset overhead.)  This is the last of several proposed
      changes in response to Philip Warner's recent report of sinval-induced
      performance problems.
      ebfc56d3
    • Tom Lane's avatar
      For multi-table ANALYZE, use per-table transactions when possible · 4d86ae42
      Tom Lane authored
      (ie, when not inside a transaction block), so that we can avoid holding
      locks longer than necessary.  Per trouble report from Philip Warner.
      4d86ae42
  4. May 22, 2004
  5. May 21, 2004
Loading