Re: Further pg_upgrade analysis for many tables

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Further pg_upgrade analysis for many tables
Дата
Msg-id m2lie2a8jc.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответ на Re: Further pg_upgrade analysis for many tables  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Further pg_upgrade analysis for many tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Could we use some adaptive mechanism here?  Say we use a list for the
> first ten entries, and if an eleventh one comes in, we create a hash
> table for that one and all subsequent ones.  All future calls would
> have to examine both the list for the first few and then the hash table.

Is it necessary to do so? Do we know for sure that a 10 elements hash
table is slower than a 10 elements list when only doing key based
lookups, for the object data type we're interested into here?

-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



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

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: User control over psql error stream
Следующее
От: Kohei KaiGai
Дата:
Сообщение: Re: [v9.3] Row-Level Security