Re: Confused about the buffer pool size
| От | MMK |
|---|---|
| Тема | Re: Confused about the buffer pool size |
| Дата | |
| Msg-id | 186583.25640.qm@web35504.mail.mud.yahoo.com обсуждение исходный текст |
| Ответ на | Re: Confused about the buffer pool size (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>) |
| Ответы |
Re: Confused about the buffer pool size
|
| Список | pgsql-hackers |
| Hello Heikki: This is what the documentation says (see below). But it does not tell my anything about what the actual buffer size is. How do I know what the real buffer size is? I am using 8.4.4 and I am running only one query at a time. Cheers, MMK. Sets the planner's assumption about the effective size of the disk cache that is available to a single query. This is factored into estimates of the cost of using an index; a higher value makes it more likely index scans will be used, a lower value makes it more likely sequential scans will be used. When setting this parameter you should consider both PostgreSQL's shared buffers and the portion of the kernel's disk cache that will be used for PostgreSQL data files. Also, take into account the expected number of concurrent queries on different tables, since they will have to share the available space. This parameter has no effect on the size of shared memory allocated by PostgreSQL, nor does it reserve kernel disk cache; it is used only for estimation purposes. The default is 128 megabytes (128MB). --- On Tue, 5/25/10, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
|
В списке pgsql-hackers по дате отправления: