Re: Sorting performance vs. MySQL

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Sorting performance vs. MySQL
Дата
Msg-id D2FE719C-F437-4264-934B-D8A90F9C201B@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на Re: Sorting performance vs. MySQL  (Yang Zhang <yanghatespam@gmail.com>)
Ответы Re: Sorting performance vs. MySQL  (Yang Zhang <yanghatespam@gmail.com>)
Список pgsql-general
On 22 Feb 2010, at 19:35, Yang Zhang wrote:

> I also wouldn't have imagined an external merge-sort as being very


Where's that external merge-sort coming from? Can you show an explain analyze?

If your work-mem is too low there's a good chance that Postgres has to use your disks for sorting, which will obviously
bequite slow. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4b82d18510442035320951!



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

Предыдущее
От: Frank Heikens
Дата:
Сообщение: Re: Sorting performance vs. MySQL
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Sorting performance vs. MySQL