Commite07d894

committed

Update FAQ.

1 parente05d246 commite07d894Copy full SHA for e07d894

File tree

-6

lines changed

-6

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:Tue May22 17:50:25 EDT 2001`
	`4`	`+ Last updated:Wed May30 18:57:52 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 BYoperations: a sequential`
`713`		`-scanfollowed by an explicit sort is faster than an indexscan of all`
`714`		`-tuplesof a large table, because it takes fewer disk accesses.`
	`712`	`+ Indexes are usually not used for ORDER BYor joins: a sequential scan`
	`713`	`+ followed by an explicit sort is faster than an indexscan of all tuples`
	`714`	`+ of a large table, because it takes fewer disk accesses.`
`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: 2 additions & 2 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:Tue May22 17:50:25 EDT 2001</P>`
	`15`	`+<P>Last updated:Wed May30 18:57:52 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,7 +908,7 @@ <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`		`-operations: a sequential scan followed by an explicit sort is`
	`911`	`+or joins: a sequential scan followed by an explicit sort is`
`912`	`912`	`faster than an indexscan of all tuples of a large table, because it`
`913`	`913`	`takes fewer disk accesses.</P>`
`914`	`914`

Comments

(0)