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

Hello. I have this problem: i'm running the postgre 7.3 on a windows 2000 server with  P3 1GHZ DUAL/1gb ram with good performance. For best performance i have change the server for a  XEON 2.4/1gb ram and for  my suprise the performance decrease 80%. anybody have a similar experience? does

[PERFORM] PostgreSql under Linux

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. Doe

[PERFORM] ext3 block size

hello. my database size is 5GB. what is the block size recommend? thanks wilson  

[PERFORM] partitioning for postgresql

hello!!! what is suggested partitioning schema for postgresql?? the size of my db is 5BG and i have 36GB scsi disk! thanks wilson