Re: Effect of large text field data on queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Glen Parker <glenebob(at)nwlink(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Effect of large text field data on queries
Date: 2006-10-26 20:26:42
Message-ID: 24951.1161894402@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Glen Parker <glenebob(at)nwlink(dot)com> writes:
> Why would very large text values effect the speed of a seq scan that
> does not actually evaluate those values?

More bytes to scan over? Have you checked the physical table sizes?

I'd actually suppose it's the smaller values (up to a few hundred bytes)
that impact this the most. Really wide fields would be pushed
out-of-line.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glen Parker 2006-10-26 20:32:26 Re: Effect of large text field data on queries
Previous Message Glen Parker 2006-10-26 19:51:17 Effect of large text field data on queries