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-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] WAL configuration and REINDEX

2006-09-24 Thread adey
Thanks Tom. How does Postgres handle page splits and redirections in indexes then please? I had an unsuccessful look at :- http://www.postgresql.org/docs/8.1/interactive/index-functions.html   and   http://www.postgresql.org/docs/8.1/interactive/indexes-types.html  On 9/25/06, Tom Lane <[EMAIL PROT

Re: [ADMIN] WAL configuration and REINDEX

2006-09-24 Thread Tom Lane
adey <[EMAIL PROTECTED]> writes: > I apologise if I am uninformed, but it is my understanding that REINDEX is > still required even with the most regular of vacuums? REINDEX shouldn't be required at all under normal circumstances. regards, tom lane ---

Re: [ADMIN] WAL configuration and REINDEX

2006-09-24 Thread adey
I apologise if I am uninformed, but it is my understanding that REINDEX is still required even with the most regular of vacuums? On 9/22/06, Jim Nasby <[EMAIL PROTECTED]> wrote: On Sep 21, 2006, at 6:40 AM, Jose Manuel Garci a Valladolid wrote:> I have a PostgreSQL 8.1.4 server under Linux Red Hat