Re: postgresql.conf

From: John Cunningham <fatbobo(at)gmail(dot)com>
To: General PostgreSQL list <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql.conf
Date: 2004-12-22 16:38:01
Message-ID: 6f782a2404122208387bd3952a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fjrhome(dot)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(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)
>
> 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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-12-22 16:39:20 Re: tool for incrementally shrinking bloated tables
Previous Message Michael Fuhr 2004-12-22 16:32:55 Re: valid using INITIALLY DEFERRED