Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Effect of large text field data on queries
- From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: Effect of large text field data on queries
- Date: Thu, 26 Oct 2006 13:36:08 -0700
On Thursday 26 October 2006 12:51, Glen Parker <glenebob(at)nwlink(dot)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
- References:
- Effect of large text field data on queries
- From: Glen Parker
- Effect of large text field data on queries
- Prev by Date: Re: Effect of large text field data on queries
- Next by Date: Re: Effect of large text field data on queries
- Previous by thread: Re: Effect of large text field data on queries
- Next by thread: schema 8.1.5
- Indexes: