Re: How can fixed and variable width columns perform similarly? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How can fixed and variable width columns perform similarly?
Date
Msg-id 15873.1177691157@sss.pgh.pa.us
Whole thread Raw
In response to How can fixed and variable width columns perform similarly?  ("Siddharth Anand" <sid@etsy.com>)
Responses Re: How can fixed and variable width columns perform similarly?  ("Siddharth Anand" <sid@etsy.com>)
List pgsql-performance
"Siddharth Anand" <sid@etsy.com> writes:
> How can a field that doesn't have a limit like "text" perform similarly to
> char varying(128), for example? At some point, we need to write data to
> disk. The more data that needs to be written, the longer the disk write
> will take, especially when it requires finding free sectors to write to.

What's your point?  If you're not going to put more than 128 characters
in the field, there's no difference in the amount of data involved.

            regards, tom lane

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Next
From: Richard Huxton
Date:
Subject: Re: [Fwd: ] How