Re: [v9.1] sepgsql - userspace access vector cache - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [v9.1] sepgsql - userspace access vector cache
Date
Msg-id 20251.1311194909@sss.pgh.pa.us
Whole thread Raw
In response to Re: [v9.1] sepgsql - userspace access vector cache  (Kohei Kaigai <Kohei.Kaigai@EMEA.NEC.COM>)
Responses Re: [v9.1] sepgsql - userspace access vector cache
List pgsql-hackers
Kohei Kaigai <Kohei.Kaigai@EMEA.NEC.COM> writes:
> I'd like to have a discussion about syscache towards next commit-fest.
> The issues may be:
>  - Initial bucket allocation on most cases never be referenced.
>  - Reclaim cache entries on growing up too large.

There used to be support for limiting the number of entries in a
syscache.  It got removed (cf commit
8b9bc234ad43dfa788bde40ebf12e94f16556b7f) because (1) it was remarkably
expensive to do it (extra list manipulations, etc), and (2) performance
tended to fall off a cliff as soon as you had a few more tables or
whatever than the caches would hold.  I'm disinclined to reverse that
decision.  It appears to me that the security label stuff needs a
different set of performance tradeoffs than the rest of the catalogs,
which means it probably ought to do its own caching, rather than trying
to talk us into pessimizing the other catalogs for seclabel's benefit.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: A few user-level questions on Streaming Replication and pg_upgrade
Next
From: Tom Lane
Date:
Subject: Re: Commitfest Status: Sudden Death Overtime