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

seeking advise on char vs text or varchar in search table

From: chrisj <chrisj(dot)wood(at)sympatico(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: seeking advise on char vs text or varchar in search table
Date: 2007-04-20 14:23:58
Message-ID: 10103002.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-performance
I have a table that contains a column for keywords that I expect to become
quite large and will be used for web searches.  I will either index the
column or come up with a simple hashing algorithm add the hash key to the
table and index that column.

I am thinking the max length in the keyword column I need to support is 30,
but the average would be less than10

Any suggestions on whether to use char(30), varchar(30) or text, would be
appreciated.  I am looking for the best performance option, not necessarily
the most economical on disk.

Or any other suggestions would be greatly appreciated.
-- 
View this message in context: http://www.nabble.com/seeking-advise-on-char-vs-text-or-varchar-in-search-table-tf3618204.html#a10103002
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


Responses

pgsql-performance by date

Next:From: Andrew LazarusDate: 2007-04-20 19:07:29
Subject: index structure for 114-dimension vector
Previous:From: Sergey TsukinovskyDate: 2007-04-19 19:29:52
Subject: postgres: 100% CPU utilization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group