diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-03-07 02:00:28 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-03-07 02:00:28 +0000 |
| commit | 1fcfa038ced8dc922b73f81de07dc0743e073082 (patch) | |
| tree | e82417511c8b65e87eb8b0479fb0d260cad303a0 | |
| parent | 849074f9ae422c64501bb1d53ef840de870bf65c (diff) | |
| download | postgresql-1fcfa038ced8dc922b73f81de07dc0743e073082.tar.gz postgresql-1fcfa038ced8dc922b73f81de07dc0743e073082.zip | |
Add a note that regression test row ordering differences can be caused
by non-default planner parameter settings.
| -rw-r--r-- | doc/src/sgml/regress.sgml | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/doc/src/sgml/regress.sgml b/doc/src/sgml/regress.sgml index 73d6ebead4b..9ba0f5d11e6 100644 --- a/doc/src/sgml/regress.sgml +++ b/doc/src/sgml/regress.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/regress.sgml,v 1.45 2004/12/28 19:08:58 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/regress.sgml,v 1.46 2005/03/07 02:00:28 tgl Exp $ --> <chapter id="regress"> <title id="regress-title">Regression Tests</title> @@ -294,21 +294,23 @@ according to the letter of the SQL specification. In practice, since we are looking at the same queries being executed on the same data by the same software, we usually get the same result ordering on all platforms, and so the lack of <literal>ORDER BY</> isn't a problem. Some queries do exhibit -cross-platform ordering differences, however. (Ordering differences -can also be triggered by non-C locale settings.) +cross-platform ordering differences, however. When testing against an +already-installed server, ordering differences can also be caused by +non-C locale settings or non-default parameter settings, such as custom values +of <varname>work_mem</> or the planner cost parameters. </para> <para> Therefore, if you see an ordering difference, it's not something to -worry about, unless the query does have an <literal>ORDER BY</> that your result -is violating. But please report it anyway, so that we can add an +worry about, unless the query does have an <literal>ORDER BY</> that your +result is violating. But please report it anyway, so that we can add an <literal>ORDER BY</> to that particular query and thereby eliminate the bogus <quote>failure</quote> in future releases. </para> <para> -You might wonder why we don't order all the regression test queries explicitly to -get rid of this issue once and for all. The reason is that that would +You might wonder why we don't order all the regression test queries explicitly +to get rid of this issue once and for all. The reason is that that would make the regression tests less useful, not more, since they'd tend to exercise query plan types that produce ordered results to the exclusion of those that don't. |