Re: Fixed width rows faster?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fixed width rows faster?
Date: 2004-03-05 23:37:02
Message-ID: 200403051537.02535.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jeff:

> As far as I know there is only a small win when you want to extract some
> field from a tuple and with variable width fields you have to walk to the
> correct field. But this is a small performance problem unless you have
> very many variable size columns in the table.

BTW, Dennis here is not talking about CHAR; CHAR is handled as a
variable-length field in Postgres. INTEGER is a fixed-width field.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Nolan 2004-03-05 23:43:33 Re: Fixed width rows faster?
Previous Message Josh Berkus 2004-03-05 23:28:55 Re: Fixed width rows faster?