Re: Hashtable entry recycling algorithm in pg_stat_statements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hashtable entry recycling algorithm in pg_stat_statements
Date
Msg-id 14884.1230945832@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hashtable entry recycling algorithm in pg_stat_statements  ("Alex Hunsaker" <badalex@gmail.com>)
Responses Re: Hashtable entry recycling algorithm in pg_stat_statements  ("Alex Hunsaker" <badalex@gmail.com>)
List pgsql-hackers
"Alex Hunsaker" <badalex@gmail.com> writes:
> Its seems to me a linear list would make the "common" case where the
> query is already in the list but we need to update the stats slow.

No, the hashtable is still there for lookups.  The list would be a means
of determining which hashtable entry to release when we're out of space.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Alex Hunsaker"
Date:
Subject: Re: Hashtable entry recycling algorithm in pg_stat_statements
Next
From: Tom Lane
Date:
Subject: Re: Significantly larger toast tables on 8.4?