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.

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 t

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

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 6

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

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 th

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

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 ap

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 Ravindran G - TLS, Chennai.
PROTECTED] Sent: Monday, August 28, 2006 7:02 PM To: Ravindran G - TLS, Chennai. Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue. Ravindran G - TLS, Chennai. wrote: > I would like to talk to one of the org member in postgre about this issue. >

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 me

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

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.

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 PROTECTE

[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 this.