On Mon, 29 Nov 1999, Oleg Bartunov wrote:
> Hi,
>
> I'm using mod_perl, DBI, ApacheDBI and was quite happy
> with persistent connections httpd<->postgres until I used
> just one database. Currently I have 20 apache servers which
> handle 20 connections to database. If I want to work with
> another database I have to create another 20 connections
> with DB. Postgres is not multithreading
> DB, so I will have 40 postgres backends. This is too much.
> Any experience ?
Does postgresql not have an equivalent to Sybase's "use database" command?
That would in effect be an adequate substitute if it did. Or even can you
reference tables explicitly:
select * from db.table
--
<Matt/>
Details: FastNet Software Ltd - XML, Perl, Databases.
Tagline: High Performance Web Solutions
Web Sites: http://come.to/fastnet http://sergeant.org
Available for Consultancy, Contracts and Training.
