On Mon, Oct 10, 2005 at 06:28:23PM +0700, Ahmad Fajar wrote:
than you can index the field and you can gain better
perfomance in searching base on the fields, because the search uses the
index you have been created.
That really depends on the queries. An index will help some queries (notably
<, = or > comparisons, or LIKE 'foo%' with the C locale), but definitely not
all (it will help you nothing for LIKE '%foo%').
If you do not need to index the field, you can use the text field. Because
text field can store data up to 4 Gbytes.
So can varchar.

/* Steinar */

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 5 | next ›
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedOct 5, '05 at 6:24p
activeOct 10, '05 at 12:54p
posts5
users4
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase