Re: postgresql.conf

From: "Frank D(dot) Engel, Jr(dot)" <fde101(at)fjrhome(dot)net>
To: General PostgreSQL list <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql.conf
Date: 2004-12-22 20:34:07
Message-ID: D3C3F9E6-5458-11D9-AF71-0050E410655F@fjrhome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Dec 22, 2004, at 2:36 PM, John Cunningham wrote:

> The shared buffers was a big concern - I've read that there's a limit
> that helps, but as the machine will only do DB transactions, I don't
> know what else to do with the RAM. It's intended for PG's use.

Try it both ways: with 32000 and with 10000. If 32000 gives you a
perceptible performance increase when numerous users are connected, use
it. Otherwise, stick with the 10000. I suspect that depending on the
queries themselves and the number of users involved, 10000 may actually
be faster than 32000, since you are freeing memory for use by other
activities within the server.

> Obviously I'd rather have fsync on - I was really looking for some
> opinions on this. Better safe than sorry - but I am trying to sqeeze
> every bit of juice possible out of this machine.

Keep it on. The tiny amount of extra performance will mean nothing if
you lose important data over it.

> The machine has 4 drives - should I do a RAID 1+0 or a 5?

1+0, definitely.

- -----------------------------------------------------------
Frank D. Engel, Jr. <fde101(at)fjrhome(dot)net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFBydpA7aqtWrR9cZoRAsgpAKCG1X+9K/5dNv9boIEdnUdEljYINACggnoD
V0rpgscodJUBWcKaIG9uEGg=
=13j7
-----END PGP SIGNATURE-----

___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey Melloy 2004-12-22 20:44:13 Memory Errors OS X
Previous Message John Cunningham 2004-12-22 19:36:59 Re: postgresql.conf