Re: performance problem - 10.000 databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marek Florianczyk <franki(at)tpi(dot)pl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance problem - 10.000 databases
Date: 2003-11-05 18:52:14
Message-ID: 3915.1068058334@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Marek Florianczyk <franki(at)tpi(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marek Florianczyk 2003-11-05 18:55:50 Re: performance problem - 10.000 databases
Previous Message Tom Lane 2003-11-05 18:34:22 Re: performance problem - 10.000 databases