Re: Postgre SQL 7.1 cygwin performance issue.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

Chris

On 8/22/06, Ravindran G - TLS, Chennai. <ravindran_g@xxxxxx> wrote:
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.

Please advise us on how to increase the performance by setting any
attributes in configuration files ?.

Find enclosed the configuration file.

Thanks and regards,
Ravi


To post a message to the mailing list, send it to
  pgsql-performance@xxxxxxxxxxxxxx


-----Original Message-----
From: pgsql-performance-owner@xxxxxxxxxxxxxx
[mailto:pgsql-performance-owner@xxxxxxxxxxxxxx]
Sent: Tuesday, August 22, 2006 5:32 PM
To: ravig3
Subject: 7E88-5CD9-AD0E : CONFIRM from pgsql-performance (subscribe)


__
The following request

  "subscribe pgsql-performance ravig3 <ravindran_g@xxxxxx>"

was sent to
by ravig3 < ravindran_g@xxxxxx>.

To accept or reject this request, please do one of the following:

1. If you have web browsing capability, visit

< http://mail.postgresql.org/mj/mj_confirm/domain=postgresql.org?t=7E88-5CD9-
AD0E>
   and follow the instructions there.

2. Reply to majordomo@xxxxxxxxxxxxxx
   with one of the following two commands in the body of the message:

    accept
    reject

   (The number 7E88-5CD9-AD0E must be in the Subject header)

3. Reply to majordomo@xxxxxxxxxxxxxx
   with one of the following two commands in the body of the message:

    accept 7E88-5CD9-AD0E
    reject 7E88-5CD9-AD0E

Your confirmation is required for the following reason(s):

  The subscribe_policy rule says that the "subscribe" command
  must be confirmed by the person affected by the command.


If you do not respond within 4 days, a reminder will be sent.

If you do not respond within 7 days, this token will expire,
and the request will not be completed.

If you would like to communicate with a person,
send mail to pgsql-performance-owner@xxxxxxxxxxxxxx.
DISCLAIMER
The contents of this e-mail and any attachment(s) are confidential and intended for the

named recipient(s) only. It shall not attach any liability on the originator or HCL or its

affiliates. Any views or opinions presented in this email are solely those of the author and

may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction,

dissemination, copying, disclosure, modification, distribution and / or publication of this

message without the prior written consent of the author of this e-mail is strictly

prohibited. If you have received this email in error please delete it and notify the sender

immediately. Before opening any mail and attachments please check them for viruses and

defect.



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux