Re: import performance

From: "Dave Dutcher" <dave(at)tridecap(dot)com>
To: "'Gavin Sherry'" <swm(at)alcove(dot)com(dot)au>, "'Chris'" <dmagick(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: import performance
Date: 2006-03-14 00:57:05
Message-ID: 000001c64702$36ad6dc0$8300a8c0@tridecap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

[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?

Dave

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gavin Sherry 2006-03-14 01:00:19 Re: import performance
Previous Message Gavin Sherry 2006-03-14 00:48:28 Re: import performance