Re: predefined role(s) for VACUUM and ANALYZE

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: predefined role(s) for VACUUM and ANALYZE
Дата
Msg-id 20220928185034.GA1397229@nathanxps13
обсуждение исходный текст
Ответ на Re: predefined role(s) for VACUUM and ANALYZE  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: predefined role(s) for VACUUM and ANALYZE  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
On Tue, Sep 20, 2022 at 09:31:26PM -0700, Nathan Bossart wrote:
> I bet a more pressing concern is the calls to aclmask() since checking
> privileges is probably done more frequently than updating them.  That
> appears to use a linear search, too, so maybe sorting the aclitem arrays is
> actually worth exploring.  I still doubt there will be much noticeable
> impact from expanding AclMode outside of the most extreme cases.

I've been testing aclmask() with long aclitem arrays (2,000 entries is
close to the limit for pg_class entries), and I haven't found any
significant impact from bumping AclMode to 64 bits.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: A potential memory leak on Merge Join when Sort node is not below Materialize node
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: predefined role(s) for VACUUM and ANALYZE