| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Marek Florianczyk <franki(at)tpi(dot)pl> |
| Cc: | Jeff <threshar(at)torgo(dot)978(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: performance problem - 10.000 databases |
| Date: | 2003-11-05 16:18:27 |
| Message-ID: | 20031105161827.GA5557@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Nov 05, 2003 at 16:14:59 +0100,
Marek Florianczyk <franki(at)tpi(dot)pl> wrote:
> One database with 3.000 schemas works better than 3.000 databases, but
> there is REAL, BIG problem, and I won't be able to use this solution:
> Every query, like "\d table" "\di" takes veeeeeeery long time.
> Users have to have phpPgAdmin wich I modified to suit our needs, but now
> it doesn't work, not even log-in. If I rewrite phpPgAdmin to log users
> without checking all schemas, and tables within schemas, none of users
> will be able to examine structure of table. Query like "\d table" from
> psql monitor takes about 2-5 MINUTES :(
Analyzing the system tables will likely make these queries go faster.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oli Sennhauser | 2003-11-05 16:19:38 | Re: Creating users in a second postgres server. |
| Previous Message | Oli Sennhauser | 2003-11-05 16:15:42 | Re: Application monitoring |