Re: How can fixed and variable width columns perform similarly?

From: Tom Lane
Subject: Re: How can fixed and variable width columns perform similarly?
Date: ,
Msg-id: 15873.1177691157@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: How can fixed and variable width columns perform similarly?  ("Siddharth Anand")
Responses: Re: How can fixed and variable width columns perform similarly?  ("Siddharth Anand")
List: pgsql-performance


"Siddharth Anand" <> 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:

From: Dan Harris
Date:
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
From: Tom Lane
Date:
Subject: Re: Very specific server situation