| From: | Brian E Gallew <geek+(at)cmu(dot)edu> |
|---|---|
| To: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1 |
| Date: | 1999-10-22 15:57:11 |
| Message-ID: | emacs-smtp-11255-14352-35159-445918@export.andrew.cmu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Then <tgl(at)sss(dot)pgh(dot)pa(dot)us> spoke up and said:
> Fernando Schapachnik <fpscha(at)ns1(dot)via-net-works(dot)net(dot)ar> writes:
> > What value would you advise for shmmax?
>
> more than the default number of buffers. But I have no advice on
> how many is appropriate for what size of installation --- can anyone
> else help?
Unless you are severely resource constrained, think big. Generally
speaking, the kilobytes of memory you'll lose to kernel structures are
irrelevant. Performance is generally not an issue, either.
--
=====================================================================
| JAVA must have been developed in the wilds of West Virginia. |
| After all, why else would it support only single inheritance?? |
=====================================================================
| Finger geek(at)cmu(dot)edu for my public key. |
=====================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-10-22 16:01:57 | Current sources fail if two 'serial' columns in one table |
| Previous Message | Tom Lane | 1999-10-22 15:33:56 | Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1 |