Re: performance problem - 10.000 databases

W liście z śro, 05-11-2003, godz. 19:34, Tom Lane pisze:
> Marek Florianczyk <franki(at)tpi(dot)pl> writes:
> > But did you do that under some database load ? eg. 100 clients
> > connected, like in my example ? When I do these queries "\d" without any
> > clients connected and after ANALYZE it's fast, but only 100 clients is
> > enough to lengthen query time to 30 sec. :(
>
> Then it's not \d's fault --- you simply don't have enough horsepower to
> support 100 concurrent clients, regardless of what specific query you're
> testing.
>
> You might find that not reconnecting so often would improve matters;
> I'm sure that a lot of your cycles are being taken by backend startup.

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 )

Marek