| From: | Martin Foster <martin(at)ethereal-realms(dot)org> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Performance on OpenBSD |
| Date: | 2003-05-19 20:09:44 |
| Message-ID: | 3EC93A08.5060203@ethereal-realms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
scott.marlowe wrote:
> I'm pretty sure sort buffer is measured in k, not 8k units. i.e.
>
> 16384 sort mem is 16 Megs.
>
> Or are you referring to something other than sort_mem?
>
It seems that you are correct. Just took a look at the configuration
file and while shared_buffers are in 8K units, or seem to be the
sort_mem is in K units meaning that I am allocating less then expected.
128 x 1024 / 8 = 16384 (shared_buffers)
20 x 1024 = 20480 (sort_mem)
Are these numbers normal? Since they start you out at considerably
higher then the default/minimum values that PostgreSQL advertises in
it's configuration file.
Martin Foster
Creator/Designer Ethereal Realms
martin(at)ethereal-realms(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-05-19 20:13:58 | Re: PostgreSQL Performance on OpenBSD |
| Previous Message | Martin Foster | 2003-05-19 20:09:41 | Re: PostgreSQL Performance on OpenBSD |