Re: Performance Question - Table Row Size - Mailing list pgsql-general

From Gregory Stark
Subject Re: Performance Question - Table Row Size
Date
Msg-id 87sl7x8gk2.fsf@oxford.xeocode.com
Whole thread Raw
In response to Performance Question - Table Row Size  (Mike <akiany@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: dropdb ; createdb equivalent without createdb permission?
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Re: xpath_* namespace bug