Index on wide varchar column

From: Antonio Sergio de Mello e Souza <asergioz(at)bol(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Index on wide varchar column
Date: 2001-10-23 21:12:22
Message-ID: 3BD5DD36.1050008@bol.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm working on an application that needs to use a big table (millions of
rows). This table has around 70 columns, one of which is a
VARCHAR(30000) that is used exclusively to sort the rows in a specific
order. The application runs in batch and reads every row of that table.
Are there any restrictions about using such a wide column to order a
table? Can an index on that column help?
Any help will be greatly appreciated.

Regards,

Antonio Sergio

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-10-23 21:25:05 Re: [GENERAL] To Postgres Devs : Wouldn't changing the select limit
Previous Message Stephanie.Wall 2001-10-23 21:06:23 Free PostgreSQL book