Re: Row Limit on tables

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: Row Limit on tables
Дата
Msg-id Pine.NEB.4.43.0206021617200.5683-100000@angelic.cynic.net
обсуждение исходный текст
Ответ на Re: Row Limit on tables  (Doug Fields <dfields-pg-general@pexicom.com>)
Список pgsql-general
On Sat, 1 Jun 2002, Doug Fields wrote:

> FYI... The Escalade controller configured as you suggest here is known to
> do 125-145mb/sec at least...

When doing database stuff, you're most likely to run into the number
of I/Os per second limit long before the bandwidth limit.

On my queries, an IDE drive perfectly cable of transferring 30
MB/sec. ends up transferring more like two or three, because it
can't do more than about 140 reads per second, and the reads are
only 16K.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


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

Предыдущее
От: "Alain Lavigne"
Дата:
Сообщение: Vacuum behaviour in plpgsql function
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Process balancing on smp db server/apache web server