Re: patch: preload dictionary new version

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: patch: preload dictionary new version
Дата
Msg-id AANLkTimE8MVl_rRS2NlkvYTKVSjNn_pS7tiePXH92EJv@mail.gmail.com
обсуждение исходный текст
Ответ на Re: patch: preload dictionary new version  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: patch: preload dictionary new version  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Список pgsql-hackers
Hello

this patch is significantly reduced original patch. It doesn't propose
a simple allocator - just eliminate a high memory usage for ispell
dictionary.

without this patch the ispell dictionary takes 55MB for tsearch2
context and 27MB in temp context. With this patch it takes "only" 25MB
tsearch2 context and 19MB in temp context - its for Czech dictionary
and UTF8 encoding. The patch is litlle bit ugly - it was reason, why I
proposed a simple allocator, but it reduce a memory usage on 53% - the
startup is better from 620 to 560 ms ~ 10% faster. little bit strange
is repeated time - it goes down from 18ms to 5ms.

Regards

Pavel Stehule

Вложения

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

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: five-key syscaches
Следующее
От: Tom Lane
Дата:
Сообщение: Re: cross column correlation revisted