ECPG - Specifying connections, TSD, sqlca.

From: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
To: "Shridhar Daithankar" <shridhar(at)frodo(dot)hserus(dot)net>
Cc: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, pgsql-hackers(at)postgresql(dot)org
Subject: ECPG - Specifying connections, TSD, sqlca.
Date: 2004-03-09 17:30:41
Message-ID: 16461.65345.751057.761165@kelvin.csl.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Shridhar, Once the patches I've put forward are applied there's still
a further change I've got planned which will remove the mutex locking
in the common case - a NULL/DEFAULT connection parameter (I'll post a
patch soon). This leaves the threaded case with comparable performance
to the non-threaded case (both have a function call to get the
connection, plus a getspecific call in the threaded case). As such is
there much benefit in adding support for the connection being supplied
by a struct pointer? You'd also have to add in something like "EXEC
SQL GET DESCRIPTION xxx" to get the pointer too. How would it improve
things over how they are in the test_thread_implicit test program?

I still think it's worthwhile investigating the use of GCC's __thread
storage class specifier to remove the use of pthread_*specific in this
case. This would also be a help to the WIN32 port since this specifier
maps well to similar constructs in Microsoft's and Borland's compilers
(see "thread" item in the TODO at developer.postgresql.org).

And I still can't see how you'll bind sqlca to the connection object,
but best of luck!

Regards, Lee K.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-03-09 17:46:01 Re: [OT] Respository [was Re: [PERFORM] Feature request: smarter
Previous Message scott.marlowe 2004-03-09 17:21:41 Re: raising the default default_statistics_target

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-03-09 19:04:52 Re: ECPG - Specifying connections, TSD, sqlca.
Previous Message Rod Taylor 2004-03-09 16:38:17 Re: [PATCHES] log_line_info