Commit227a584

committed

Update FAQ.

1 parente07d894 commit227a584Copy full SHA for 227a584

File tree

-7

lines changed

-7

lines changed

Lines changed: 3 additions & 3 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 May 3018:57:52 EDT 2001`
	`4`	`+ Last updated: Wed May 3019:00:33 EDT 2001`
`5`	`5`
`6`	`6`	`Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)`
`7`	`7`
`@@ -709,9 +709,9 @@ Maximum number of indexes on a table? unlimited`
`709`	`709`	`column statistics on its own, so VACUUM ANALYZE must be run to collect`
`710`	`710`	`them periodically.`
`711`	`711`
`712`		`- Indexes are usually not used for ORDER BY or joins: a sequential scan`
	`712`	`+ Indexes are usually not used for ORDER BY or joins. A sequential scan`
`713`	`713`	`followed by an explicit sort is faster than an indexscan of all tuples`
`714`		`- of a large table, because it takes fewer diskaccesses.`
	`714`	`+ of a large table. This is because random diskaccess is very slow.`
`715`	`715`
`716`	`716`	`When using wild-card operators such as LIKE or ~, indices can only be`
`717`	`717`	`used if the beginning of the search is anchored to the start of the`

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -12,7 +12,7 @@`
`12`	`12`	`alink="#0000FF">`
`13`	`13`	`<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>`
`14`	`14`
`15`		`-<P>Last updated: Wed May 3018:57:52 EDT 2001</P>`
	`15`	`+<P>Last updated: Wed May 3019:00:33 EDT 2001</P>`
`16`	`16`
`17`	`17`	`<P>Current maintainer: Bruce Momjian (<Ahref=`
`18`	`18`	`"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>`
`@@ -908,9 +908,9 @@ <H4><A name="4.9">4.9</A>) My queries are slow or don't make use of`
`908`	`908`	`periodically.</P>`
`909`	`909`
`910`	`910`	`<P>Indexes are usually not used for<SMALL>ORDER BY</SMALL>`
`911`		`- or joins: a sequential scan followed by an explicit sort is`
`912`		`- faster than an indexscan of all tuples of a large table, because it`
`913`		`-takes fewerdiskaccesses.</P>`
	`911`	`+ or joins. A sequential scan followed by an explicit sort is`
	`912`	`+ faster than an indexscan of all tuples of a large table. This`
	`913`	`+is because randomdiskaccess is very slow.</P>`
`914`	`914`
`915`	`915`	`<P>When using wild-card operators such as<SMALL>LIKE</SMALL> or`
`916`	`916`	`<I>~,</I> indices can only be used if the beginning of the search`

Comments

(0)