From e8b842b9d3c65bf76157b3093bb8540ff1d5dea2 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 11 Aug 2005 13:22:07 +0000 Subject: [PATCH] Update MD5 mention for long values. --- doc/FAQ | 8 ++++---- doc/src/FAQ/FAQ.html | 6 +++--- 2 files changed, 7 insertions(+), 7 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index e1c3cf1999..23994765bf 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Wed Aug 10 15:29:42 EDT 2005 + Last updated: Thu Aug 11 09:21:58 EDT 2005 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -474,9 +474,9 @@ One limitation is that indexes can not be created on columns longer than about 2,000 characters. Fortunately, such indexes are rarely - needed. Uniqueness is best guaranteed using another column that is an - MD5 hash of the long column, and full text indexing allows for - searching of words within the column. + needed. Uniqueness is best guaranteed by a funtion index of an MD5 + hash of the long column, and full text indexing allows for searching + of words within the column. 4.5) How much database disk space is required to store data from a typical text file? diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 07dd956e2e..2d46904eb3 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Wed Aug 10 15:29:42 EDT 2005

+

Last updated: Thu Aug 11 09:21:58 EDT 2005

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -619,8 +619,8 @@ table?unlimited

One limitation is that indexes can not be created on columns longer than about 2,000 characters. Fortunately, such indexes are - rarely needed. Uniqueness is best guaranteed using another column - that is an MD5 hash of the long column, and full text indexing + rarely needed. Uniqueness is best guaranteed by a funtion index + of an MD5 hash of the long column, and full text indexing allows for searching of words within the column.

4.5) How much database disk space is required -- 2.11.0