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 */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
