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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sid(at)etsy(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How can fixed and variable width columns perform similarly?
Date: 2007-04-27 16:25:57
Message-ID: 15873.1177691157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Siddharth Anand" <sid(at)etsy(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2007-04-27 16:40:15 Re: How can fixed and variable width columns perform similarly?
Previous Message Siddharth Anand 2007-04-27 16:19:04 Re: How can fixed and variable width columns perform similarly?