[ADMIN] best OS and HW for postgreSQL

2006-09-22 Thread Raul Retamozo
Hi everyone on the list. I want to know what is the reccommended OS to work with PostgreSQL , on specific with PostGIS: One more question is about what HW (server) offers the best performance for a Web Map Server bases on PostGIS and mapserver.     Thanks in advance. raul n. retamozo velarde [EM

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-24 Thread Jim Nasby
On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote: Hi everyone on the list. I want to know what is the reccommended OS to work with PostgreSQL , on specific with PostGIS: One more question is about what HW (server) offers the best performance for a Web Map Server bases on PostGIS and mapserver.

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-24 Thread Guido Neitzer
Hi. On 9/25/06, Jim Nasby <[EMAIL PROTECTED]> wrote: As for hardware, until recently, AMD was the un-disputed king when it came to running PostgreSQL (and databases in general). But the newer Intel CPUs seem to have surpassed the Opteron. I believe there's a tweakers.net article floating around

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Scott Marlowe
On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote: > On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote: > > Hi everyone on the list. I want to know what is the reccommended OS > > to work with PostgreSQL , on specific with PostGIS: > > One more question is about what HW (server) offers the best

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Ray Stell
I'm curious about the "[ADMIN] COPY FROM command v8.1.4" thread as it applies to this thread.The COPY thread pointed to kernel issues in x86_64 GNU/Linux SLES 9. I'm wondering if x86_64 is not a good move for pg servers at this time. Are there happy x86_64 production deployments? On Mon,

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Hakan Kocaman
amozo; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] best OS and HW for postgreSQL > > > > I'm curious about the "[ADMIN] COPY FROM command v8.1.4" thread > as it applies to this thread.The COPY thread pointed to kernel > issues in x86_64 GNU/Linux SLE

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Joshua D. Drake
Scott Marlowe wrote: On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote: On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote: Hi everyone on the list. I want to know what is the reccommended OS to work with PostgreSQL , on specific with PostGIS: One more question is about what HW (server) offers

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Scott Marlowe
On Mon, 2006-09-25 at 10:28, Joshua D. Drake wrote: > Scott Marlowe wrote: > > On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote: > >> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote: > >>> Hi everyone on the list. I want to know what is the reccommended OS > >>> to work with PostgreSQL , on sp

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Joshua D. Drake
Much more important is your disk subsystem. Using an Areca RAID controller with battery backed cache and a half dozen or more hard drives is often the real winner for performance. Yes, LSI and 3Ware are also good. I am particularly fond of LSI but Areca has PCI-Express cards which means you ca

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Joshua D. Drake
Ray Stell wrote: I'm curious about the "[ADMIN] COPY FROM command v8.1.4" thread as it applies to this thread.The COPY thread pointed to kernel issues in x86_64 GNU/Linux SLES 9. I'm wondering if x86_64 is not a good move for pg servers at this time. Are there happy x86_64 production deplo

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Chris Browne
[EMAIL PROTECTED] ("Joshua D. Drake") writes: > Scott Marlowe wrote: >> On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote: >>> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote: Hi everyone on the list. I want to know what is the reccommended OS to work with PostgreSQL , on specific wit

Re: [ADMIN] best OS and HW for postgreSQL

2006-09-25 Thread Bill Hernandez
On Sep 25, 2006, at 6:43 AM, Guido Neitzer wrote: Hi. On 9/25/06, Jim Nasby <[EMAIL PROTECTED]> wrote: As for hardware, until recently, AMD was the un-disputed king when it came to running PostgreSQL (and databases in general). But the newer Intel CPUs seem to have surpassed the Opteron. I b