Re: Optimizing POSTGRESQL config

Le Fri, 02 May 2003 16:22:00 +0200
Manfred Koizar <mkoi-pg(at)aon(dot)at> a écrit:

>
> Who sold you a 1.2 GHz machine with 128 MB? Next time better buy
> 600 MHz and 256 MB RAM ;-) So the short answer is: Buy more
> memory. OTOH you *can* configure Postgres to run satisfactorily on
> small hardware.
>
I agree with you, memory seem to be more important than CPU speed.
(But it's not easy to found now less than 4 GHz CPU speed at the street corner)

Have you an idea how to configure an AMD 800 MHz with 512 Mo of RAM
for <= 16 users ?

> 32 MB sort mem together with 90 MB shared memory, so a single sort
> can cause your system to start swapping, not to mention Apache and
> other processes running on that system...
>
Without Apache or others ... for now.

> >fsync = false
>
> Only do this if you don't care for consistency after a crash.

Really dangerous with a Mylex DAC960 Accelraid ... wich seem
to sync when it want ?
>
> >LC_MESSAGES = 'en_US.iso885915'
> >LC_MONETARY = 'en_US.iso885915'
> >LC_NUMERIC = 'en_US.iso885915'
> >LC_TIME = 'en_US.iso885915'
>
> This may slow down certain kinds of queries, locale C seems to be a
> better choice if you have speed in mind. Search the archives for
> details.
>
Can you explain a little more or give the archives references ?

Many thanks for answer,
--
Alain Lucari (Eurlix)