Fwd: Re: [ANNOUNCE] PostgreSQL Weekly News - July 30th 2003

Started by Robert Treatover 22 years ago2 messages
#1Robert Treat
xzilla@users.sourceforge.net

Hey Thierry,

I'm forwarding this on to the hackers group to see if we can get an
authoritative answer, as you don't want to rely on my fuzzy memory. :-)
Anyone know the scoop on this?

Robert Treat

---------- Forwarded Message ----------

Subject: Re: [ANNOUNCE] PostgreSQL Weekly News - July 30th 2003
Date: Thursday 31 July 2003 03:24
From: Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-announce@postgresql.org

Hi,

Nothing is said about "Multi-threaded use of SQLCA" in 7.4.

I have developed a pgBench in PRO*C with each Client symbolized by a User
Thread. It runs on Oracle 9i but, on PostgreSQL, it crashes or hang after a
while due to the the fact that the Postgres ProC 7.3.2 isn't thread-safe.

I have read in the TODO list that SQLCA is planed to be Thread_Safe in 7.4.
Will it be ?

Thierry

Robert Treat wrote:

== PostgreSQL Weekly News - July 30th 2003 ==

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

#2Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Robert Treat (#1)
Re: Fwd: Re: [ANNOUNCE] PostgreSQL Weekly News - July 30th

Yes, ecpg will be thread-safe in 7.4.

---------------------------------------------------------------------------

Robert Treat wrote:

Hey Thierry,

I'm forwarding this on to the hackers group to see if we can get an
authoritative answer, as you don't want to rely on my fuzzy memory. :-)
Anyone know the scoop on this?

Robert Treat

---------- Forwarded Message ----------

Subject: Re: [ANNOUNCE] PostgreSQL Weekly News - July 30th 2003
Date: Thursday 31 July 2003 03:24
From: Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-announce@postgresql.org

Hi,

Nothing is said about "Multi-threaded use of SQLCA" in 7.4.

I have developed a pgBench in PRO*C with each Client symbolized by a User
Thread. It runs on Oracle 9i but, on PostgreSQL, it crashes or hang after a
while due to the the fact that the Postgres ProC 7.3.2 isn't thread-safe.

I have read in the TODO list that SQLCA is planed to be Thread_Safe in 7.4.
Will it be ?

Thierry

Robert Treat wrote:

== PostgreSQL Weekly News - July 30th 2003 ==

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073