Jean Huveneers wrote: > Hi, > > Within an couple of weeks we will start using PostgreSQL on Mandrake 8.1 > in real business (we have been testing, for over a half year). > > In future we will have some tables with 100.000+ records an the system > has te work very fast. > > I know that speed of querries depend much on the amount of availible RAM > to PostgreSQL, the server will only run the databases. What amount is > RAM is usefull (I meen, does Postgres use the RAM, if availible, up to 2 > GB)? > > I'm can chose for a Dual Athlon MP on a Tyan Thunder K7 motherbord, but > does PostgreSQL use the 2 processors? > > Regards, > > Jean Huveneers > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
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
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 6: Have you searched our list archives? http://archives.postgresql.org
