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