Index on wide column

From: Antonio Sergio de Mello e Souza <asergioz(at)bol(dot)com(dot)br>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Index on wide column
Date: 2001-10-24 15:51:53
Message-ID: 3BD6E399.9030503@bol.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I need to perform a tree traversal on a big table (millions of rows).
To avoid recursive queries, one for each non-leaf node, this table has,
in addition to its 70 columns, a VARCHAR(30000) column that is used
exclusively to sort the rows with the required order. The actual content
length in that column is expected to be, on average, much less than the
declared limit and the text will be composed of digits and letters only.

Please, are there any restrictions about using such a wide column to
order a table? Can an index on that column help?

I'm running PostgreSQL 7.1.2, on Linux 2.2.16, compiled with options:
--prefix=/usr/local/pgsql --enable-locale --enable-multibyte

Regards,

Antonio Sergio

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Doug McNaught 2001-10-24 16:27:37 Re: PQconnectStart() and -EINTR
Previous Message Arguile 2001-10-24 15:38:38 New default ignored by pre-exising insert rulesets.