Re: Inefficient bytea escaping?

Поиск
Список
Период
Сортировка
Искать
От
Marko Kreen
Тема
Re: Inefficient bytea escaping?
Дата
в 08:45:47
Msg-id
e51f66da0605280445l18b12d1cw1587cfa34437e983@mail.gmail.com
Ответ на
Re: Inefficient bytea escaping? (Martijn van Oosterhout)
Список
Дерево обсуждения
Inefficient bytea escaping? Andreas Pflug <pgadmin@pse-consulting.de>
Re: Inefficient bytea escaping? Tom Lane <tgl@sss.pgh.pa.us>
Re: Inefficient bytea escaping? Andreas Pflug <pgadmin@pse-consulting.de>
Re: Inefficient bytea escaping? Tom Lane <tgl@sss.pgh.pa.us>
Re: Inefficient bytea escaping? Andreas Pflug <pgadmin@pse-consulting.de>
Re: Inefficient bytea escaping? Tom Lane <tgl@sss.pgh.pa.us>
Re: Inefficient bytea escaping? Tom Lane <tgl@sss.pgh.pa.us>
Re: Inefficient bytea escaping? Tom Lane <tgl@sss.pgh.pa.us>
Re: Inefficient bytea escaping? Andreas Pflug <pgadmin@pse-consulting.de>
Re: Inefficient bytea escaping? "Marko Kreen" <markokr@gmail.com>
Re: Inefficient bytea escaping? Tom Lane <tgl@sss.pgh.pa.us>
Re: Inefficient bytea escaping? "Marko Kreen" <markokr@gmail.com>
Re: Inefficient bytea escaping? Martijn van Oosterhout <kleptog@svana.org>
Re: Inefficient bytea escaping? "Marko Kreen" <markokr@gmail.com>
Re: Inefficient bytea escaping? Martijn van Oosterhout <kleptog@svana.org>
Re: Inefficient bytea escaping? "Marko Kreen" <markokr@gmail.com>
Re: Inefficient bytea escaping? Bruce Momjian <pgman@candle.pha.pa.us>
Re: Inefficient bytea escaping? "Marko Kreen" <markokr@gmail.com>
Re: Inefficient bytea escaping? Thomas Hallgren <thomas@tada.se>
Re: Inefficient bytea escaping? Andreas Pflug <pgadmin@pse-consulting.de>
On 5/28/06, Martijn van Oosterhout  wrote:
> With -lpthread
> lock.enabled     323s
> lock.disabled     50s
> lock.unlocked     36s

I forgot to test with -lpthread, my bad.  Indeed by default
something less expensive that full locking is going on.

> The crux of the matter is though, if you're calling something a million
> times, you're better off trying to find an alternative anyway. There is
> a certain amount of overhead to calling shared libraries and no amount
> of optimisation of the library is going save you that.

The crux of the matter was if its possible to use fwrite
as easy string combining mechanism and the answer is no,
because it's not lightweight enough.

-- 
marko

В списке pgsql-hackers по дате отправления
От: Rémi Zara
Дата:
От: Martijn van Oosterhout
Дата:
FAQ