Manuel Trujillo wrote:

> 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         [EMAIL PROTECTED]
> Technical Engineer      http://www.motograndprix.com
> Dorna Sports S.L.       +34 93 4702864

Si prefieres hablamos en español.


we're currently working on a 8-processor sgi server with irix by now each
backend run in one processor there is no load balance
the amount of memory u will need is as I know (table size+indexes size) they are
in your base directory, if u can afford it then u will be working on memory
but fsync and walfiles
hope it help

begin:vcard 
n:Amigo Navarro;Luis Alberto
tel;cell:609581857
x-mozilla-html:FALSE
org:Universidad de Cantabria;Arquitectura de Computadores
adr:;;Avda Los Castros S/N	;Santander;Cantabria;39005;España
version:2.1
email;internet:[EMAIL PROTECTED]
x-mozilla-cpt:;0
fn:Luis Amigo
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to