[ADMIN] Postgresql slow on XEON 2.4ghz/1gb ram

2003-08-14 Thread Wilson A. Galafassi Jr.
Hello. I have this problem:i'm runningthe postgre 7.3on awindows 2000 serverwith P3 1GHZ DUAL/1gb ramwithgood performance.For bestperformancei have change the server for a XEON 2.4/1gb ram andformy suprisethe performance decrease 80%.anybody have a similar experience?does exist anyspecial

[ADMIN] ext3 block size

2003-08-07 Thread Wilson A. Galafassi Jr.
hello. my database size is 5GB. what is the block size recommend? thanks wilson

[ADMIN] PostgreSql under Linux

2003-08-06 Thread Wilson A. Galafassi Jr.
Hello people. I'm installing Postgresql under linux for better performance and i want to know how is the best configuration. My server is a dual pentium3 1ghz/1gb ram/36gb scsi. running only postgresql. My question is: 1. What is the best linux distribuition for better performance? 2. Does