aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2012-04-08 15:49:47 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2012-04-08 15:49:47 -0400
commitd5375491f8e391224b48e4bb449995a4642183ea (patch)
tree47c02e82b2379f7d7fdfc8a71f535119df775d0a /doc/src
parent03529a3ff999b0e4770b3e0b8e342400e383db98 (diff)
downloadpostgresql-d5375491f8e391224b48e4bb449995a4642183ea.tar.gz
postgresql-d5375491f8e391224b48e4bb449995a4642183ea.zip
Improve management of "sticky" entries in contrib/pg_stat_statements.
This patch addresses a deficiency in the previous pg_stat_statements patch. We want to give sticky entries an initial "usage" factor high enough that they probably will stick around until their query is completed. However, if the query never completes (eg it gets an error during execution), the entry shouldn't persist indefinitely. Manage this by starting out with a usage setting equal to the (approximate) median usage value within the whole hashtable, but decaying the value much more aggressively than we do for normal entries. Peter Geoghegan
Diffstat (limited to 'doc/src')
0 files changed, 0 insertions, 0 deletions