Re: [HACKERS] Improve catcache/syscache performance.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Improve catcache/syscache performance.
Дата
Msg-id 20171013181719.m6f45x6aqs7yxjpl@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] Improve catcache/syscache performance.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Improve catcache/syscache performance.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 2017-10-13 14:07:54 -0400, Tom Lane wrote:
> One idea might be to see if we can precalculate all the control data
> needed for the caches and set it up as compile-time constants,
> a la Gen_fmgrtab.pl, rather than reading it from the catalogs during
> startup.  That would make the code less dependent on initialization
> order rather than more so.

Hm. That sounds somewhat enticing. You're thinking of doing so for
catcaches alone, or something grander, including the relcaches? I'd
assume the former?

For catcaches the hardest part probably is that we need a TupleDesc. Per
type function lookups, oids, should be fairly easy in contrast.

Greetings,

Andres Freund


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Re: protocol version negotiation (Re: LibpqPGRES_COPY_BOTH - version compatibility)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Improve catcache/syscache performance.