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

From Alan Hodgson
Subject Re: Effect of large text field data on queries
Date
Msg-id 200610261336.09011@hal.medialogik.com
Whole thread Raw
In response to Effect of large text field data on queries  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
On Thursday 26 October 2006 12:51, Glen Parker <glenebob@nwlink.com> wrote:
> Why would very large text values effect the speed of a seq scan that
> does not actually evaluate those values?

Seq scan reads the whole table.  The limiting factor is the size of the
table on disk.

--
"If a nation expects to be ignorant and free, in a state of civilization,
it expects what never was and never will be." -- Thomas Jefferson


pgsql-general by date:

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