| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: shared_buffer=2*max_connections? |
| Date: | 2001-07-20 20:52:27 |
| Message-ID: | 200107202052.f6KKqR117037@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I see in postgresql.conf what seems to be the suggested way to go:
>
> #shared_buffers = 2*max_connections # min 16
>
> This seems to imply that every connection is to take 16kb of shmem on average. From my understanding this depends on the size of the query->involved relations, the sort_mem size etc.etc.
It is assuming two 8k buffers per backend. They are shared. This is
just an estimate and probably doesn't accurately show how many you will
need for your query load.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-20 20:52:59 | Re: shared_buffer=2*max_connections? |
| Previous Message | IRWIN,KEITH (Non-HP-Corvallis,ex1) | 2001-07-20 20:51:04 | Does dropping a column from a table mess up foreign keys? |