Re: Postgres con 16GB de RAM

jose javier parra sanchez escribió:
> Quieres decir en la version de 64Bits ?, si es asi, hay mas de un
> kernel ?, imagino que seran con capacidades extra como maquinas
> virtuales, en fin, el mas basico deberia servir.
>
>
> 2009/10/14 Edwin Quijada <listas_quijada(at)hotmail(dot)com>:
>
>> Estoy usando debian Lenny y bno se cual kernel poder ponerle
>>
>>
>> *-------------------------------------------------------*
>> *-Edwin Quijada
>> *-Developer DataBase
>> *-JQ Microsistemas
>> *-Soporte PostgreSQL
>> *-www.jqmicrosistemas.com
>> *-809-849-8087
>> *-------------------------------------------------------*
>>
>>
>>
>>
>>
>> ________________________________
>> Date: Wed, 14 Oct 2009 09:54:35 -0500
>> Subject: Re: [pgsql-es-ayuda] Postgres con 16GB de RAM
>> From: juanmarquezr(at)gmail(dot)com
>> To: listas_quijada(at)hotmail(dot)com
>> CC: r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no; jojapasa(at)gmail(dot)com;
>> pgsql-es-ayuda(at)postgresql(dot)org
>>
>> con ese hardware porque no montaste un sistema de 64Bit de arrancada?
>>
>> tienes escopeta para matar moscas, es imperativo que te pases a un OS-Linux
>> de 64Bit y aprovecha al maximo tus recursos.
>>
>> exitos.
>>
>> 2009/10/14 Edwin Quijada <listas_quijada(at)hotmail(dot)com>
>>
>>
>>
>>> ¿Que CPU tiene tu servidor?
>>>
>> processor : 0
>> vendor_id : GenuineIntel
>> cpu family : 15
>> model : 4
>> model name : Intel(R) Xeon(TM) CPU 3.20GHz
>> stepping : 3
>> cpu MHz : 3192.366
>> cache size : 2048 KB
>> physical id : 0
>> siblings : 2
>> core id : 0
>> cpu cores : 1
>> apicid : 0
>> initial apicid : 0
>> fdiv_bug : no
>> hlt_bug : no
>> f00f_bug : no
>> coma_bug : no
>> fpu : yes
>> fpu_exception : yes
>> cpuid level : 5
>> wp : yes
>> flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
>> cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm
>> constant_tsc pebs bts pni monitor ds_cpl cid cx16 xtpr
>> bogomips : 6389.95
>> clflush size : 64
>> power management:
>>
>> processor : 1
>> vendor_id : GenuineIntel
>> cpu family : 15
>> model : 4
>> model name : Intel(R) Xeon(TM) CPU 3.20GHz
>> stepping : 3
>> cpu MHz : 3192.366
>> cache size : 2048 KB
>> physical id : 3
>> siblings : 2
>> core id : 0
>> cpu cores : 1
>> apicid : 6
>> initial apicid : 6
>> fdiv_bug : no
>> hlt_bug : no
>> f00f_bug : no
>> coma_bug : no
>> fpu : yes
>> fpu_exception : yes
>> cpuid level : 5
>> wp : yes
>> flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
>> cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm
>> constant_tsc pebs bts pni monitor ds_cpl cid cx16 xtpr
>> bogomips : 6384.42
>> clflush size : 64
>> power management:
>>
>>
>> processor : 2
>> vendor_id : GenuineIntel
>> cpu family : 15
>> model : 4
>> model name : Intel(R) Xeon(TM) CPU 3.20GHz
>> stepping : 3
>> cpu MHz : 3192.366
>> cache size : 2048 KB
>> physical id : 0
>> siblings : 2
>> core id : 0
>> cpu cores : 1
>> apicid : 1
>> initial apicid : 1
>> fdiv_bug : no
>> hlt_bug : no
>> f00f_bug : no
>> coma_bug : no
>> fpu : yes
>> fpu_exception : yes
>> cpuid level : 5
>> wp : yes
>> flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
>> cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm
>> constant_tsc pebs bts pni monitor ds_cpl cid cx16 xtpr
>> bogomips : 6384.35
>> clflush size : 64
>> power management:
>>
>>
>> processor : 3
>> vendor_id : GenuineIntel
>> cpu family : 15
>> model : 4
>> model name : Intel(R) Xeon(TM) CPU 3.20GHz
>> stepping : 3
>> cpu MHz : 3192.366
>> cache size : 2048 KB
>> physical id : 3
>> siblings : 2
>> core id : 0
>> cpu cores : 1
>> apicid : 7
>> initial apicid : 7
>> fdiv_bug : no
>> hlt_bug : no
>> f00f_bug : no
>> coma_bug : no
>> fpu : yes
>> fpu_exception : yes
>> cpuid level : 5
>> wp : yes
>> flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
>> cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm
>> constant_tsc pebs bts pni monitor ds_cpl cid cx16 xtpr
>> bogomips : 6384.46
>> clflush size : 64
>> power management:
>>
>>
>>
>>
>>
>> *-------------------------------------------------------*
>> *-Edwin Quijada
>> *-Developer DataBase
>> *-JQ Microsistemas
>> *-Soporte PostgreSQL
>> *-www.jqmicrosistemas.com
>> *-809-849-8087
>> *-------------------------------------------------------*
>>
>>
>>
>>
>>
>> ________________________________
>>
>>
>> --
>> JUAN MARQUEZ RUIZ
>> Ingeniero de Sistemas y Telecomunicaciones
>> Cel 3013841546
>>
>> ________________________________
>>
> --
> TIP 1: para suscribirte y desuscribirte, visita http://archives.postgresql.org/pgsql-es-ayuda
>
Pudieras compilar el kernel para tu hardware específicamente, pero sería
trivial a mi entender, ya que con
tus recursos da para mucho sin tener que hacerlo.
Instala la versión de Lenny de 64 bits y ya resolverías muchos de tus
problemas.

Saludos

--
"DBAs must implement decisions based on the best fit of application, DBMS, and platform
...........for that reason I use BSD + PostgreSQL + Linux.........................."

Ing. Marcos Luís Ortíz Valmaseda
Centro de Tecnologías de Almacenamiento y Anális de Datos (CENTALAD)
Universidad de las Ciencias Informáticas

Linux User # 418229

http://www.freebsd.org
http://www.openbsd.org
http://www.postgresql-es.org
http://www.postgresql.org
http://www.planetpostgresql.org