Need help with Dead Lock - reg.

[Shanmugasundaram Doraisamy]

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

[mike g]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[mike g]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Shanmugasundaram Doraisamy]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Shanmugasundaram Doraisamy]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Mike G]

I would consider the default probably an optimum value. If you are having to increase it to keep your applications working then there are other issues that need to be addressed. Increasing it might keep the applications "working" but the users 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

Mike G <mi**@thegodshalls.com> writes:

On Sat, 2004-06-19 at 13:12, Shanmugasundaram Doraisamy wrote:

Is there a way to increase the time of Dead Lock?
The default is set to 1000 msec.

I would consider the default probably an optimum value. If you are
having to increase it to keep your applications working then there are
other issues that need to be addressed.

AFAIK, neither increasing nor decreasing that timeout will have the
slightest effect on whether your apps get deadlock failures. All it
does is determine how quickly an existing deadlock is detected.
A shorter timeout means you wait less long to be told of a deadlock,
but it also causes more cycles to be spent checking for deadlocks
that may not exist. If you've got apps that are designed not to ever
deadlock, then you might want to kick the timeout up a lot to ensure
you don't waste time on deadlock checks even under heavy load.

So I'm wondering what the OP's problem *really* is; whatever it is,
I doubt that fooling with deadlock_timeout will solve it.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html