Re: [PERFORM] A Better External Sort?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [PERFORM] A Better External Sort?
Дата
Msg-id 200510031416.15620.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: [PERFORM] A Better External Sort?  ("Jeffrey W. Baker" <jwbaker@acm.org>)
Ответы Re: [PERFORM] A Better External Sort?  ("Luke Lonergan" <llonergan@greenplum.com>)
Re: [PERFORM] A Better External Sort?  ("Jeffrey W. Baker" <jwbaker@acm.org>)
Re: [PERFORM] A Better External Sort?  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
Jeff,

> > Nope, LOTS of testing, at OSDL, GreenPlum and Sun.   For comparison, A
> > Big-Name Proprietary Database doesn't get much more than that either.
>
> I find this claim very suspicious.  I get single-threaded reads in
> excess of 1GB/sec with XFS and > 250MB/sec with ext3.

Database reads?  Or raw FS reads?  It's not the same thing.

Also, we're talking *write speed* here, not read speed.

I also find *your* claim suspicious, since there's no way XFS is 300% faster
than ext3 for the *general* case.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: effective SELECT from child tables
Следующее
От: Ron Peacetree
Дата:
Сообщение: Re: [PERFORM] A Better External Sort?