Re: Performance Question - Table Row Size

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Mike" <akiany(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance Question - Table Row Size
Date: 2007-07-09 20:31:41
Message-ID: 87sl7x8gk2.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mike" <akiany(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2007-07-09 20:33:04 Re: xpath_* namespace bug
Previous Message Tom Lane 2007-07-09 20:31:30 Re: dropdb ; createdb equivalent without createdb permission?