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