Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Thu, 26 Oct 2006 12:51:17 -0700
  • Message-id: <454111B5(dot)90001(at)nwlink(dot)com>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group