Commit1415a83

committed

Update hash warning in manual.

1 parentebe4375 commit1415a83Copy full SHA for 1415a83

File tree

+10

-8

lines changed

+10

-8

lines changed

Lines changed: 5 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.32 2002/06/2103:25:53 momjian Exp $ -->`
	`1`	`+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.33 2002/06/2116:52:00 momjian Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="indexes">`
`4`	`4`	`<title id="indexes-title">Indexes</title>`
`@@ -181,9 +181,10 @@ CREATE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable>`
`181`	`181`	`</synopsis>`
`182`	`182`	`<note>`
`183`	`183`	`<para>`
`184`		`- Testing has shown that hash indexes are slower than btree indexes,`
`185`		`- and the size and build time for hash indexes is much worse. For`
`186`		`- these reasons, hash index use is discouraged.`
	`184`	`+ Testing has shown hash indexes to be similar or slower than btree`
	`185`	`+ indexes, and the index size and build time for hash indexes is much`
	`186`	`+ worse. Hash indexes also suffer poor performance under high`
	`187`	`+ concurrency. For these reasons, hash index use is discouraged.`
`187`	`188`	`</para>`
`188`	`189`	`</note>`
`189`	`190`	`</para>`

Lines changed: 5 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.32 2002/06/2103:25:53 momjian Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.33 2002/06/2116:52:00 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -330,9 +330,10 @@ ERROR: Cannot create index: 'index_name' already exists.`
`330`	`330`	`the <literal>=</literal> operator.`
`331`	`331`	`</para>`
`332`	`332`	`<para>`
`333`		`- Testing has shown that hash indexes are slower than btree indexes,`
`334`		`- and the size and build time for hash indexes is much worse. For`
`335`		`- these reasons, hash index use is discouraged.`
	`333`	`+ Testing has shown hash indexes to be similar or slower than btree`
	`334`	`+ indexes, and the index size and build time for hash indexes is much`
	`335`	`+ worse. Hash indexes also suffer poor performance under high`
	`336`	`+ concurrency. For these reasons, hash index use is discouraged.`
`336`	`337`	`</para>`
`337`	`338`
`338`	`339`	`<para>`

Comments

(0)