Re: Joins and full index scans...mysql vs postgres?

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: Joins and full index scans...mysql vs postgres?
Дата
Msg-id 43FD8CA6.10802@pse-consulting.de
обсуждение исходный текст
Ответ на Re: Joins and full index scans...mysql vs postgres?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance
Christopher Kings-Lynne wrote:
> The pgAdmin query tool is known to give an answer about 5x the real
> answer - don't believe it!

Everybody please forget immediately the factor 5. It's no factor at all,
but the GUI update time that is *added*, which depends on rows*columns.


> ryan groth wrote:
>
>> the pgadmin query tool saying that the query runs
>> "997+3522 ms".

Means 997ms until all data is at the client (libpq reports the rowset),
the rest is GUI overhead.

Regards,
Andreas

В списке pgsql-performance по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Good News re count(*) in 8.1
Следующее
От: Kjeld Peters
Дата:
Сообщение: Created Index is not used