Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Ravindran G - TLS, Chennai.
I would like to talk to one of the org member in postgre about this issue. This is critical for us. Please help. It will be great, if you could provide your contact number to discuss on this. Thank you in advance. Regards, Ravi -Original Message- From: Ravindran G - TLS, Chennai.

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Alvaro Herrera
Ravindran G - TLS, Chennai. wrote: I would like to talk to one of the org member in postgre about this issue. This is critical for us. Please help. It will be great, if you could provide your contact number to discuss on this. Sure, we're happy to help. You can contact several org members

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Christopher Browne
On 8/28/06, Ravindran G - TLS, Chennai. [EMAIL PROTECTED] wrote: Thanks Alvaro. We are using PostgreSQL 7.1 cygwin installed on Windows 2000. We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. But our application is installed in 8 / 10 PC or more than

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread A. Kretschmer
am Mon, dem 28.08.2006, um 19:30:44 +0530 mailte Ravindran G - TLS, Chennai. folgendes: Thanks Alvaro. We are using PostgreSQL 7.1 cygwin installed on Windows 2000. *grrr* We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. But our

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Alvaro Herrera
Ravindran G - TLS, Chennai. wrote: Thanks Alvaro. We are using PostgreSQL 7.1 cygwin installed on Windows 2000. We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. This is because of Cygwin limitations. But our application is installed in 8 / 10

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Christopher Browne
On 8/28/06, Alvaro Herrera [EMAIL PROTECTED] wrote: Please advise us on how to resolve this ?. There's no solution short of upgrading. That's a little too negative. There is at least one alternative, possibly two... 1. Migrate the database to a Unix platform that does not suffer from the

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Scott Marlowe
On Mon, 2006-08-28 at 09:00, Ravindran G - TLS, Chennai. wrote: Thanks Alvaro. We are using PostgreSQL 7.1 cygwin installed on Windows 2000. We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. But our application is installed in 8 / 10 PC or

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Joshua D. Drake
Ravindran G - TLS, Chennai. wrote: Hi, We are using PostgreSQL 7.1 cygwin installed on Windows 2000 (2 GB Memory, P4). I would strongly suggest moving to native 8.1 :). You will find your life much better. Joshua D. Drake We understand that the maximum connections that can be set is

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Tom Lane
Christopher Browne [EMAIL PROTECTED] writes: On 8/28/06, Alvaro Herrera [EMAIL PROTECTED] wrote: There's no solution short of upgrading. That's a little too negative. There is at least one alternative, possibly two... But both of those would probably involve work comparable to an upgrade.

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Christopher Browne
On 8/28/06, Tom Lane [EMAIL PROTECTED] wrote: Christopher Browne [EMAIL PROTECTED] writes: On 8/28/06, Alvaro Herrera [EMAIL PROTECTED] wrote: There's no solution short of upgrading. That's a little too negative. There is at least one alternative, possibly two... But both of those would

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Merlin Moncure
On 8/28/06, Christopher Browne [EMAIL PROTECTED] wrote: On 8/28/06, Tom Lane [EMAIL PROTECTED] wrote: Christopher Browne [EMAIL PROTECTED] writes: On 8/28/06, Alvaro Herrera [EMAIL PROTECTED] wrote: There's no solution short of upgrading. That's a little too negative. There is at least

[PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-22 Thread Ravindran G - TLS, Chennai.
Hi, We are using PostgreSQL 7.1 cygwin installed on Windows 2000 (2 GB Memory, P4). We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. The performance is very slow and some time the database is not getting connected from our application because of

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-22 Thread Chris Hoover
Is there a reason you are not upgrading to PostgreSQL 8.1? it will run natively on Windoze, and will give you much better performance. 7.1 is way out of date, and has a lot of bad issues in it.Upgrading will most likely fix this issue. ChrisOn 8/22/06, Ravindran G - TLS, Chennai. [EMAIL PROTECTED]

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-22 Thread Tom Lane
Ravindran G - TLS, Chennai. [EMAIL PROTECTED] writes: We are using PostgreSQL 7.1 cygwin installed on Windows 2000 (2 GB Memory, P4). Egad :-( If you are worried about performance, get off 7.1. Even if you are not worried about performance, get off 7.1. It *will* eat your data someday. A