I would consider the default probably an optimum value. If you are having to increase it to keep your applications
workingthen there are other issues that need to be addressed. Increasing it might keep the applications "working" but
theusers will probably still complain about the poor performance of it.
On Mon, Jun 21, 2004 at 07:14:16PM +0530, Shanmugasundaram Doraisamy wrote:
> Dear Mike,
> Thank you for your response. I have made the
> required changes. But is there any optimum value for this?
>
> Regards,
> Shan.
>
> mike g wrote:
>
> >I believe that setting can be found in your postgresql.conf file.
> >Change it there and restart the postmaster.
> >
> >Mike
> >On Sat, 2004-06-19 at 13:12, Shanmugasundaram Doraisamy wrote:
> >
> >
> >>Dear Group,
> >> Is there a way to increase the time of Dead Lock?
> >>The default is set to 1000 msec.
> >>
> >>Regards,
> >>Shan.
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 7: don't forget to increase your free space map settings
> >>
> >>