Skip site navigation (1) Skip section navigation (2)

Re: performance problem - 10.000 databases

From: Marek Florianczyk <franki(at)tpi(dot)pl>
To: Matt Clark <matt(at)ymogen(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance problem - 10.000 databases
Date: 2003-10-31 11:08:08
Message-ID: 1067598488.22286.69.camel@franki-laptop.tpi.pl (view raw or flat)
Thread:
Lists: pgsql-admin
W liście z pią, 31-10-2003, godz. 11:52, Matt Clark pisze: 
> > I could made persistent connection, but with 10.000 clients it will kill
> > the server.
> 
> But if they're virtual domains, why would you need one connection per domain?  You should only need one connection per apache
> process...

Because every virtual domain has its own database, username and
password. So one client domain1.com with db: domain1db user: domain1user
cannot access to second client database domain2.com db: domain2db user:
domain2user
pg_hba.conf look like this:
host	domain1db	domain1user	ip_addr	netmask	md5
host	domain2db	domain2user	ip_addr	netmask	md5
.....
....
10.000 records
...
...
host	domain10000db	domain10000user	ip_addr	netmask	md5


You know,  one client cannot access to other client database.
So, if one process is connected to domain1db it cannto access to
domain2db, and others.


greetings
Marek


In response to

Responses

pgsql-admin by date

Next:From: Matt ClarkDate: 2003-10-31 11:25:21
Subject: Re: performance problem - 10.000 databases
Previous:From: Matt ClarkDate: 2003-10-31 10:52:07
Subject: Re: performance problem - 10.000 databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group