Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit39b9c9f

Browse files
committed
Reduce default selectivity estimates for geometric operators; it seems
the old ones were not small enough to ensure r-tree and gist indexes wouldget picked when available. These numbers are totally bogus anyway, butin the absence of any real estimation technique, we'd like to selectindexes when available ...
1 parent83b4ab5 commit39b9c9f

File tree

1 file changed

+5
-5
lines changed

1 file changed

+5
-5
lines changed

‎src/backend/utils/adt/geo_selfuncs.c

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@
99
*
1010
*
1111
* IDENTIFICATION
12-
* $Header: /cvsroot/pgsql/src/backend/utils/adt/geo_selfuncs.c,v 1.18 2001/01/24 19:43:14 momjian Exp $
12+
* $Header: /cvsroot/pgsql/src/backend/utils/adt/geo_selfuncs.c,v 1.19 2001/02/15 17:55:17 tgl Exp $
1313
*
1414
*XXX These are totally bogus. Perhaps someone will make them do
1515
*something reasonable, someday.
@@ -47,13 +47,13 @@
4747
Datum
4848
areasel(PG_FUNCTION_ARGS)
4949
{
50-
PG_RETURN_FLOAT8(0.02);
50+
PG_RETURN_FLOAT8(0.005);
5151
}
5252

5353
Datum
5454
areajoinsel(PG_FUNCTION_ARGS)
5555
{
56-
PG_RETURN_FLOAT8(0.02);
56+
PG_RETURN_FLOAT8(0.005);
5757
}
5858

5959
/*
@@ -85,11 +85,11 @@ positionjoinsel(PG_FUNCTION_ARGS)
8585
Datum
8686
contsel(PG_FUNCTION_ARGS)
8787
{
88-
PG_RETURN_FLOAT8(0.01);
88+
PG_RETURN_FLOAT8(0.001);
8989
}
9090

9191
Datum
9292
contjoinsel(PG_FUNCTION_ARGS)
9393
{
94-
PG_RETURN_FLOAT8(0.01);
94+
PG_RETURN_FLOAT8(0.001);
9595
}

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp