On Wed, Nov 05, 2003 at 16:14:59 +0100, Marek Florianczyk <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster