Re: PGconn thread safety

Поиск
Список
Период
Сортировка
От Lee Kindness
Тема Re: PGconn thread safety
Дата
Msg-id 15939.30960.430288.147731@kelvin.csl.co.uk
обсуждение исходный текст
Ответ на Re: PGconn thread safety  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Ответы Re: PGconn thread safety
Список pgsql-general
Well the areas I have patched would have /potentially/ caused
inaccurate error messages (using global errno). Also potential
corruption on connect to database if 2+ threads were trying to do this
at once - a non-threadsafe fucntion was being used to retrieve all
local usernames.

I've been a bit busy of late, the code itself is submitted to
pgsql-patches but configure work is still to be done.

L.

Shridhar Daithankar writes:
 > On Friday 07 February 2003 12:44 pm, you wrote:
 > > Neil Conway <neilc@samurai.com> writes:
 > > That's the theory anyway.  I believe it actually is free of unsafe uses
 > > of static variables.  However, someone recently pointed out that it uses
 > > some libc routines that probably aren't thread-safe; so there's some
 > > cleanup yet to do before we can claim real thread safety.
 >
 > Well, I ran a mutlithreaded test where around 30 connections were hammered in
 > a mutlihtreaded servers using libpq for 100,000 transactions. I didn't notice
 > any data inconsistency.
 >
 > Only noticable thing was that postgresql was not returning even simplest
 > result in less than 200 ms. So in order to achieve a good throughput, I had
 > to up the number of connections. The max throughput. was 200ms/no. of
 > connections.
 >
 > but that is a different issue..
 >
 >  Shridhar

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

Предыдущее
От: will trillich
Дата:
Сообщение: Re: converting Oracle to postgres
Следующее
От: will trillich
Дата:
Сообщение: inherited, unique serial field...