Re: [PERFORM] Hardware performance

2003-07-16 Thread Joe Conway
Balazs Wellisch wrote: first of all I'd like to thank everyone who responded to my earlier post. I have a much better understanding of postgres performance tuning now. In case anyone's interested we've decided to go with RH9 and PostgreSQL 7.3 and we'll do the OS and DB tuning ourselves. (should be

Re: [PERFORM] Hardware performance

2003-07-16 Thread Roman Fail
I've got a Dell 2650 set up with 5 drives and a separate app server connecting with JDBC. Since you've only got 5 drives, my conclusion regarding the best balance of performance and redundancy was: 2 drives have the OS, swap, and WAL in RAID-1 3 drives have the data in RAID-5 If you can affo

[PERFORM] Hardware performance

2003-07-16 Thread Balazs Wellisch
Hi all,   first of all I'd like to thank everyone who responded to my earlier post. I have a much better understanding of postgres performance tuning now. In case anyone's interested we've decided to go with RH9 and PostgreSQL 7.3 and we'll do the OS and DB tuning ourselves. (should be a goo

Re: [PERFORM] Bad performance using ODBC

2003-07-16 Thread Tom Lane
Albert Cervera Areny <[EMAIL PROTECTED]> writes: > I have a performance problem using postgresql when the connection is made > via ODBC with a windows machine using the latests ODBC drivers (Windows) and > PostgreSQL 7.3.3 (Linux). Do you have logging turned on in the ODBC driver? I recall he

[PERFORM] Bad performance using ODBC

2003-07-16 Thread Albert Cervera Areny
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have a performance problem using postgresql when the connection is made via ODBC with a windows machine using the latests ODBC drivers (Windows) and PostgreSQL 7.3.3 (Linux). The queries made by my Visual Basic program are very very simple