Re: Effect of large text field data on queries - Mailing list pgsql-general

From Tom Lane
Subject Re: Effect of large text field data on queries
Date
Msg-id 24951.1161894402@sss.pgh.pa.us
Whole thread Raw
In response to Effect of large text field data on queries  (Glen Parker <glenebob@nwlink.com>)
Responses Re: Effect of large text field data on queries
List pgsql-general
Glen Parker <glenebob@nwlink.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

pgsql-general by date:

Previous
From: Glen Parker
Date:
Subject: Effect of large text field data on queries
Next
From: Glen Parker
Date:
Subject: Re: Effect of large text field data on queries