Thread: Connections and threading problems

Connections and threading problems

From
"Stergios Zissakis"
Date:
Hi there,

I have set up PGSQL 7.4 and unixODBC-2.2.8 on Solaris 8 (with the 113261-02
patch applied).
I'm using OTL 4 and a multi-threaded test program.
I encountered the following problems.
1) I cannot get more than 5 threads to connect to the databse at the same
time.
   See the attached cons.log
2) When my program runs (with 5 threads) the threads seem to be serialized
rather than compete with each other.
   See the attached threads.log

Please find attached the following files:
odbc.ini
odbcinst.ini
PGSQL config files
show_all.txt #the output of "show all" in psql
insert.cc  #my source

Thanks in advance.
Stergios




Attachment

Re: Connections and threading problems

From
Richard Huxton
Date:
On Thursday 04 March 2004 12:39, Stergios Zissakis wrote:
> Hi there,
>
> I have set up PGSQL 7.4 and unixODBC-2.2.8 on Solaris 8 (with the 113261-02
> patch applied).
> I'm using OTL 4 and a multi-threaded test program.
> I encountered the following problems.
> 1) I cannot get more than 5 threads to connect to the databse at the same
> time.

Your log file says you've reached your maximum number of connections.

2004-03-04 14:24:09 LOG:  connection authorized: user=szis database=test
2004-03-04 14:24:09 FATAL:  sorry, too many clients already

You'll want to increase max_connections in your postgresql.conf. Make sure PG
re-reads the file.

You also *do not* want to leave enable_seqscan set to false unless you are
testing.

--
  Richard Huxton
  Archonet Ltd