Effect of large text field data on queries

From: Glen Parker <glenebob(at)nwlink(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Effect of large text field data on queries
Date: 2006-10-26 19:51:17
Message-ID: 454111B5.90001@nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am having some query problems on a table with large text fields.

The table contains 6.7M rows. It is vacuumed every night, and since the
last vacuum, rows have been inserted only, never updated or deleted.

There are many large text field values in one text field, some in excess
of 6MB.

I have another table with 13.8M rows, several times as many columns, but
no large text values.

I am testing select count() queries on both tables, counting on an
integer field only. The first table takes almost 300 seconds to
complete, while the second table takes about 90 seconds.

Why would very large text values effect the speed of a seq scan that
does not actually evaluate those values?

Oh, PG 8.1.3 on FC 5, 64-bit.

TIA
-Glen Parker

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-10-26 20:26:42 Re: Effect of large text field data on queries
Previous Message Ottavio Campana 2006-10-26 19:46:43 Re: more than 32 parameters to a function?