diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-02-15 17:55:17 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-02-15 17:55:17 +0000 |
| commit | 39b9c9f2213c52bf3947bebc2702ecfd1a7d23f4 (patch) | |
| tree | 3eedeeff77a108c1f978b218c706f1fbb339b725 | |
| parent | 83b4ab53ada6ce3286af1dc9ecdd69e678be9f72 (diff) | |
| download | postgresql-39b9c9f2213c52bf3947bebc2702ecfd1a7d23f4.tar.gz postgresql-39b9c9f2213c52bf3947bebc2702ecfd1a7d23f4.zip | |
Reduce default selectivity estimates for geometric operators; it seems
the old ones were not small enough to ensure r-tree and gist indexes would
get picked when available. These numbers are totally bogus anyway, but
in the absence of any real estimation technique, we'd like to select
indexes when available ...
| -rw-r--r-- | src/backend/utils/adt/geo_selfuncs.c | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/backend/utils/adt/geo_selfuncs.c b/src/backend/utils/adt/geo_selfuncs.c index 087b72aa653..a0d72348244 100644 --- a/src/backend/utils/adt/geo_selfuncs.c +++ b/src/backend/utils/adt/geo_selfuncs.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/geo_selfuncs.c,v 1.18 2001/01/24 19:43:14 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/geo_selfuncs.c,v 1.19 2001/02/15 17:55:17 tgl Exp $ * * XXX These are totally bogus. Perhaps someone will make them do * something reasonable, someday. @@ -47,13 +47,13 @@ Datum areasel(PG_FUNCTION_ARGS) { - PG_RETURN_FLOAT8(0.02); + PG_RETURN_FLOAT8(0.005); } Datum areajoinsel(PG_FUNCTION_ARGS) { - PG_RETURN_FLOAT8(0.02); + PG_RETURN_FLOAT8(0.005); } /* @@ -85,11 +85,11 @@ positionjoinsel(PG_FUNCTION_ARGS) Datum contsel(PG_FUNCTION_ARGS) { - PG_RETURN_FLOAT8(0.01); + PG_RETURN_FLOAT8(0.001); } Datum contjoinsel(PG_FUNCTION_ARGS) { - PG_RETURN_FLOAT8(0.01); + PG_RETURN_FLOAT8(0.001); } |