From: | Tianyin Xu <tixu(at)cs(dot)ucsd(dot)edu> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | "shared_buffers" and "temp_buffers" why manual and code are different? |
Date: | 2013-11-23 07:30:50 |
Message-ID: | CABBDWweA4gPrTVt9zQRiM5mDGe50QDQ4gLF5zxOFn=Ez8oMuGg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I want to tune the memory usage of PG (9.3.1) on my environment. I'm really
confused by the following two configuration parameters,
shared_buffers,
temp_buffers,
Take "shared_buffers" as the example, the manual says,
"Sets the amount of memory the database server uses for shared memory
buffers. The default is typically 128 megabytes (128MB), .... This setting
must be at least 128 kilobytes. "
However, when I look at the configuration code (below), the code shows it
should be the number of shared memory buffers *NOT* the size of the buffer
.
/* guc.c */
1638 {"shared_buffers", PGC_POSTMASTER, RESOURCES_MEM,
1639 gettext_noop("Sets the number of shared memory buffers
used by the server."),
1640 NULL,
1641 GUC_UNIT_BLOCKS
1642 },
1643 &NBuffers,
1644 1024, 16, INT_MAX / 2,
1645 NULL, NULL, NULL
So which one is correct?
Also, what exactly is the default value? The manual says that the default
is 128MB while the min is 128KB. But from the code, you can clearly see
that it's not the case.
Thank you very much!
Best regards,
Tianyin
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2013-11-23 08:09:04 | Re: PG replication across DataCenters |
Previous Message | Ken Tanzer | 2013-11-23 06:41:57 | Re: Getting non_NULL right-side values on a non-matching join? |