Re: Maximum Performance

From: Manuel Trujillo <manueltrujillo(at)dorna(dot)es>
To: Luis Amigo <lamigo(at)atc(dot)unican(dot)es>
Cc: Jean Huveneers <j(dot)huveneers(at)farcourier(dot)com>, pg-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Maximum Performance
Date: 2002-01-24 09:00:26
Message-ID: 1011862828.14774.10.camel@klingon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

El jue, 24-01-2002 a las 09:27, Luis Amigo escribió:
> On my own experience I will tell you that if you're able to force postgres
> to keep all database in memory it will be very fast, so memory only depends
> on your
> database size.
> Each backend may run on a different processor, so the more processors u
> have the more backends u can run at once
> hope it helps

Yes, but... How can I know the exact size of my database? And, if I
compile the postgresql under four processors, don't work like (or in a)
SMP, distributing the charge into the four processors??

--
Manuel Trujillo manueltrujillo(at)dorna(dot)es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Florian Helmberger 2002-01-24 09:01:01 Re: timing a process
Previous Message Luis Amigo 2002-01-24 08:27:09 Re: Maximum Performance