Skip site navigation (1) Skip section navigation (2)

Re: How are text columns stored?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: meetesh(dot)karia(at)alumni(dot)duke(dot)edu
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How are text columns stored?
Date: 2005-06-28 06:18:44
Message-ID: 11351.1119939524@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Meetesh Karia <meetesh(dot)karia(at)gmail(dot)com> writes:
> According to section 8.3 of the doc:

> "Long values are also stored in background tables so they do not interfere
> with rapid access to the shorter column values."

> So, how long does a value have to be to be considered "long"?

Several kilobytes.

			regards, tom lane

In response to

pgsql-performance by date

Next:From: Michael FuhrDate: 2005-06-28 06:26:20
Subject: Re: Postgresql7.4.5 running slow on plpgsql function
Previous:From: Tobias BroxDate: 2005-06-28 06:03:33
Subject: Re: Too slow querying a table of 15 million records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group