Re: patch: preload dictionary new version - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: patch: preload dictionary new version
Date
Msg-id AANLkTimE8MVl_rRS2NlkvYTKVSjNn_pS7tiePXH92EJv@mail.gmail.com
Whole thread Raw
In response to Re: patch: preload dictionary new version  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: patch: preload dictionary new version
List 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

Attachment

pgsql-hackers by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: five-key syscaches
Next
From: Tom Lane
Date:
Subject: Re: cross column correlation revisted