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
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. |