diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-28 20:04:38 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-28 20:04:38 +0000 |
| commit | 1c1ecd5124068a45fdecc0dcc4ba2581c15acf9f (patch) | |
| tree | c7ecc0e07e153f32c35c4450e018b73c8570c72a /src/backend/optimizer/plan/planner.c | |
| parent | 485375a1c9270fb3eefe4b9391dd976e563c2c1c (diff) | |
| download | postgresql-1c1ecd5124068a45fdecc0dcc4ba2581c15acf9f.tar.gz postgresql-1c1ecd5124068a45fdecc0dcc4ba2581c15acf9f.zip | |
Improve planner estimates for size of tuple hash tables.
Diffstat (limited to 'src/backend/optimizer/plan/planner.c')
| -rw-r--r-- | src/backend/optimizer/plan/planner.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c index ea6a052918e..da1cadcd0db 100644 --- a/src/backend/optimizer/plan/planner.c +++ b/src/backend/optimizer/plan/planner.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.199 2006/03/05 15:58:29 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.200 2006/06/28 20:04:38 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -1298,7 +1298,7 @@ choose_hashed_grouping(PlannerInfo *root, double tuple_fraction, } /* Estimate per-hash-entry space at tuple width... */ - hashentrysize = cheapest_path_width; + hashentrysize = MAXALIGN(cheapest_path_width) + MAXALIGN(sizeof(MinimalTupleData)); /* plus space for pass-by-ref transition values... */ hashentrysize += agg_counts->transitionSpace; /* plus the per-hash-entry overhead */ |