Re: Optimizing POSTGRESQL config

On Fri, 2 May 2003 22:55:15 +0200, eurlix <eurlix@libertysurf.fr>
wrote:
> 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)

 :-) and it's equally hard to find a new PC with less than 1 GB <g>.

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

Without any knowledge about your database size and usage patterns,
only vague ideas  -  I'd start with

    shared_buffers = 1000
    sort_mem = 4096
    effective_cache_size = 50000

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

Google for something like
    locale index like
or
    default locale considered harmful

Servus
 Manfred