Commite8b842b

committed

Update MD5 mention for long values.

1 parent6a60357 commite8b842bCopy full SHA for e8b842b

File tree

-7

lines changed

-7

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`
`2`	`2`	`Frequently Asked Questions (FAQ) for PostgreSQL`
`3`	`3`
`4`		`- Last updated:Wed Aug10 15:29:42 EDT 2005`
	`4`	`+ Last updated:Thu Aug11 09:21:58 EDT 2005`
`5`	`5`
`6`	`6`	`Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)`
`7`	`7`
`@@ -474,9 +474,9 @@`
`474`	`474`
`475`	`475`	`One limitation is that indexes can not be created on columns longer`
`476`	`476`	`than about 2,000 characters. Fortunately, such indexes are rarely`
`477`		`- needed. Uniqueness is best guaranteedusing another column that is an`
`478`		`-MD5hash of the long column, and full text indexing allows for`
`479`		`-searchingof words within the column.`
	`477`	`+ needed. Uniqueness is best guaranteedby a funtion index of an MD5`
	`478`	`+ hash of the long column, and full text indexing allows for searching`
	`479`	`+ of words within the column.`
`480`	`480`
`481`	`481`	`4.5) How much database disk space is required to store data from a typical`
`482`	`482`	`text file?`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`alink="#0000ff">`
`11`	`11`	`<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>`
`12`	`12`
`13`		`-<P>Last updated:Wed Aug10 15:29:42 EDT 2005</P>`
	`13`	`+<P>Last updated:Thu Aug11 09:21:58 EDT 2005</P>`
`14`	`14`
`15`	`15`	`<P>Current maintainer: Bruce Momjian (<Ahref=`
`16`	`16`	`"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)`
`@@ -619,8 +619,8 @@ <H3><A name="4.4">4.4</A>) What is the maximum size for a row, a`
`619`	`619`
`620`	`620`	`<P>One limitation is that indexes can not be created on columns`
`621`	`621`	`longer than about 2,000 characters. Fortunately, such indexes are`
`622`		`- rarely needed. Uniqueness is best guaranteedusing another column`
`623`		`-that is an MD5 hash of the long column, and full text indexing`
	`622`	`+ rarely needed. Uniqueness is best guaranteedby a funtion index`
	`623`	`+of an MD5 hash of the long column, and full text indexing`
`624`	`624`	`allows for searching of words within the column.</P>`
`625`	`625`
`626`	`626`	`<H3><Aname="4.5">4.5</A>) How much database disk space is required`

Comments

(0)