| From: | Gavin Sherry <swm(at)alcove(dot)com(dot)au> |
|---|---|
| To: | Dave Dutcher <dave(at)tridecap(dot)com> |
| Cc: | "'Chris'" <dmagick(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: import performance |
| Date: | 2006-03-14 01:00:19 |
| Message-ID: | Pine.LNX.4.58.0603141159210.16412@linuxworld.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, 13 Mar 2006, Dave Dutcher wrote:
> [Snip]
> > >
> > > shared_buffers = 256
> >
> > Make this higher too. If this is a dedicated machine with 512 MB of
> ram,
> > set it to something like 125000.
> >
> > You may need to adjust shared memory settings for your operating
> system.
> > See the manual for details.
> >
>
> Whoa. Maybe I'm wrong, but isn't each buffer 8192 bytes? So you are
> suggesting that he set his shared buffers to a gigabyte on a machine
> with 512 MB of ram? Or was that just a miscalculation?
One to many zeros. Oops.
Gavin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris | 2006-03-14 01:24:22 | Re: import performance |
| Previous Message | Dave Dutcher | 2006-03-14 00:57:05 | Re: import performance |