Re: performance problem - 10.000 databases - Mailing list pgsql-admin

From Tom Lane
Subject Re: performance problem - 10.000 databases
Date
Msg-id 3915.1068058334@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
Responses Re: performance problem - 10.000 databases
List pgsql-admin
Marek Florianczyk <franki@tpi.pl> writes:
> Maybe reconnect is to often, but how to explain that reular queries like
> select * from table1 ale much faster than \d's ? ( my post to Jeff )

[ further experimentation... ]  Ah-hah, I see the problem in 7.3, though
not in 7.4 which is what I was testing to begin with.  7.4 is smarter
about optimizing the LEFT JOINs that are used in \d's queries.

            regards, tom lane

pgsql-admin by date:

Previous
From: Marek Florianczyk
Date:
Subject: Re: performance problem - 10.000 databases
Next
From: Marek Florianczyk
Date:
Subject: Re: performance problem - 10.000 databases