Re: Performance Question - Table Row Size

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Performance Question - Table Row Size
Дата
Msg-id 87sl7x8gk2.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Performance Question - Table Row Size  (Mike <akiany@gmail.com>)
Список pgsql-general
"Mike" <akiany@gmail.com> writes:

> I am designing my database and I was wondering whether my table row
> size effects the performance of querying my table.

yes

If your table is large and you're reading all the rows then you'll be limited
by the i/o rate. If your rows are twice as big it will take twice as much i/o
to read and it will take twice as long.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: dropdb ; createdb equivalent without createdb permission?
Следующее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Re: xpath_* namespace bug