Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Дата
Msg-id 4648.1226942529@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> The point here is to do the work at postmaster start time.  You won't
>> get a chance to find out whether both languages are defined in some
>> database or other.  (This is the same thing as the point about the
>> UTF8 hack --- you can't tell if it's needed or not.)

> w.r.t. UTF8, I guess we'll need a way of knowing if we're preloading or 
> not, and if so we'd need to skip the calls to GetDatabaseEncoding().

If you mean that you want to still do the UTF8 hack at backend start
time, I think you might as well not bother with any of this.  That hack
in itself is slow enough to be 50% of the problem (presumably because
it's loading some modules down in there somewhere).  We need to arrange
to either not do it at all or do it at preload.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Synchronous replication patch v2
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;