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