Re: less than 2 sec for response - possible?

Поиск
Список
Период
Сортировка
От trafdev
Тема Re: less than 2 sec for response - possible?
Дата
Msg-id fbea2bea-63dc-f721-4e0e-82f9abe5e3ea@mail.ru
обсуждение исходный текст
Ответ на Re: less than 2 sec for response - possible?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: less than 2 sec for response - possible?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-performance
>>> The difference is - you're fetching\grouping 8 times less rows than I:
>
> Huh? The explain output certainly doesn't show that.

Why not?

My output:
Buffers: shared hit=1486949

Torsten's output:
Buffers: shared hit=155711

This is amount of rows fetched for further processing (when all data is
in memory), isn't it?


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: DELETE takes too much memory
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: less than 2 sec for response - possible?