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
