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: (view raw or whole 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 with db: domain1db user: domain1user
cannot access to second client database db: domain2db user:
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.


In response to


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-2015 The PostgreSQL Global Development Group