Re: Fixed width rows faster? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Fixed width rows faster?
Date
Msg-id 200403051537.02535.josh@agliodbs.com
Whole thread Raw
In response to Re: Fixed width rows faster?  (Dennis Bjorklund <db@zigo.dhs.org>)
List 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


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Fixed width rows faster?
Next
From: Mike Nolan
Date:
Subject: Re: Fixed width rows faster?