Re: Postgre SQL 7.1 cygwin performance issue.

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(at)hcl(dot)in> 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(at)postgresql(dot)org
>
>
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org]
> 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(at)hcl(dot)in>"
>
> was sent to
> by ravig3 <ravindran_g(at)hcl(dot)in>.
>
> 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(at)postgresql(dot)org
> 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(at)postgresql(dot)org
> 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(at)postgresql(dot)org(dot)
> 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
>
>
>
>