diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-12 00:36:12 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-12 00:36:12 +0000 |
| commit | 77a7e9968bf109d11b87c40ba41d4b1a7f1d28ea (patch) | |
| tree | e33aa3030956bcc878a3181e9cd31efad38b0d6c /src/backend/utils/misc | |
| parent | e44beef712144316cb83d32ccf3231a1503c9655 (diff) | |
| download | postgresql-77a7e9968bf109d11b87c40ba41d4b1a7f1d28ea.tar.gz postgresql-77a7e9968bf109d11b87c40ba41d4b1a7f1d28ea.zip | |
Change memory-space accounting mechanism in tuplesort.c and tuplestore.c
to make a reasonable attempt at accounting for palloc overhead, not just
the requested size of each memory chunk. Since in many scenarios this
will make for a significant reduction in the amount of space acquired,
partially compensate by doubling the default value of SORT_MEM to 1Mb.
Per discussion in pgsql-general around 9-Jun-2002..
Diffstat (limited to 'src/backend/utils/misc')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 4 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index ebb4a7d89bb..d94010cb598 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -5,7 +5,7 @@ * command, configuration file, and command line options. * See src/backend/utils/misc/README for more information. * - * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.78 2002/08/07 17:26:24 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.79 2002/08/12 00:36:11 tgl Exp $ * * Copyright 2000 by PostgreSQL Global Development Group * Written by Peter Eisentraut <peter_e@gmx.net>. @@ -556,7 +556,7 @@ static struct config_int { { "sort_mem", PGC_USERSET }, &SortMem, - 512, 4 * BLCKSZ / 1024, INT_MAX, NULL, NULL + 1024, 8 * BLCKSZ / 1024, INT_MAX, NULL, NULL }, { diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index be097186cac..c9511ad7fb1 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -57,7 +57,7 @@ # # Non-shared Memory Sizes # -#sort_mem = 512 # min 32 +#sort_mem = 1024 # min 64 #vacuum_mem = 8192 # min 1024 |