Re: Protect syscache from bloating with negative cache entries - Mailing list pgsql-hackers

From MauMau
Subject Re: Protect syscache from bloating with negative cache entries
Date
Msg-id 7BB6D08FB81C4690BC01741E6B7B1692@tunaPC
Whole thread Raw
In response to Re: Protect syscache from bloating with negative cache entries  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
From: Alvaro Herrera
> I think seqscanning the hash table is going to be too slow;
Ideriha-san
> idea of having a dlist with the entries in LRU order (where each
entry
> is moved to head of list when it is touched) seemed good: it allows
you
> to evict older ones when the time comes, without having to scan the
rest
> of the entries.  Having a dlist means two more pointers on each
cache
> entry AFAIR, so it's not a huge amount of memory.

Absolutely.  We should try to avoid unpredictable long response time
caused by an occasional unlucky batch processing.  That makes the
troubleshooting when the user asks why they experience unsteady
response time.

Regards
MauMau







pgsql-hackers by date:

Previous
From: Raúl Marín
Date:
Subject: Re: [PATCH] pgbench tap tests fail if the path contains a perl special character
Next
From: Tom Lane
Date:
Subject: Re: ON SELECT rule on a table without columns