Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

async.c

Blame
    • Tom Lane's avatar
      ca5646fc
      Fix UNLISTEN to fall out quickly if the current backend has never executed · ca5646fc
      Tom Lane authored
      any LISTEN command.  This is more important than it used to be because
      DISCARD ALL invokes UNLISTEN.  Connection-pooled applications making heavy
      use of DISCARD ALL were seeing significant contention for pg_listener,
      as reported by Matteo Beccati.  It seems unlikely that clients using LISTEN
      would use pooled connections, so this simple tweak seems sufficient,
      especially since the pg_listener implementation is slated to go away soon
      anyway.
      
      Back-patch to 8.3, where DISCARD ALL was introduced.
      ca5646fc
      History
      Fix UNLISTEN to fall out quickly if the current backend has never executed
      Tom Lane authored
      any LISTEN command.  This is more important than it used to be because
      DISCARD ALL invokes UNLISTEN.  Connection-pooled applications making heavy
      use of DISCARD ALL were seeing significant contention for pg_listener,
      as reported by Matteo Beccati.  It seems unlikely that clients using LISTEN
      would use pooled connections, so this simple tweak seems sufficient,
      especially since the pg_listener implementation is slated to go away soon
      anyway.
      
      Back-patch to 8.3, where DISCARD ALL was introduced.