Re: postgresql.conf - Mailing list pgsql-general

From John Cunningham
Subject Re: postgresql.conf
Date
Msg-id 6f782a2404122208387bd3952a@mail.gmail.com
Whole thread Raw
In response to Re: postgresql.conf  ("Frank D. Engel, Jr." <fde101@fjrhome.net>)
Responses Re: postgresql.conf  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
I'm running Red Hat Enterprise ES with all the most recent updates.

The error - in initdb - was that the system couldn't find
"ascii_and_mic" libraries.  7.3.6 ran without a hitch.

The RAID 1+0 - is that a stripped / mirrored condifuration?  How big
of a difference will that make in performance do you think - are we
talking 10 % or leaps and bounds?

The help is much appreciated - I'm reading that tuning manual now.

-John




On Wed, 22 Dec 2004 10:59:43 -0500, Frank D. Engel, Jr.
<fde101@fjrhome.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> On Dec 22, 2004, at 10:15 AM, John Cunningham wrote:
>
> > like to configure it to get the most out of the server possible as far
> > as shared memory, sort memore, etc.  I haven't found a lot of
> > documentation on this.
>
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
>
> - -----------------------------------------------------------
> Frank D. Engel, Jr.  <fde101@fjrhome.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)
>
> iD8DBQFByZnw7aqtWrR9cZoRAgl8AJ9PcpktGBeA/Oboh5+ZKPwS1niP9QCfZaL3
> yf1Yvav5baMeQZOjGmvmk6E=
> =Hnti
> -----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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
>

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: valid using INITIALLY DEFERRED
Next
From: Martijn van Oosterhout
Date:
Subject: Re: tool for incrementally shrinking bloated tables