Re: performance problem - 10.000 databases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: performance problem - 10.000 databases
Дата
Msg-id 3915.1068058334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
Ответы Re: performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
Список 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 по дате отправления:

Предыдущее
От: Marek Florianczyk
Дата:
Сообщение: Re: performance problem - 10.000 databases
Следующее
От: Marek Florianczyk
Дата:
Сообщение: Re: performance problem - 10.000 databases