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
6  1470 
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, Shanmugasundara m 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 YourEmailAddres sHere" to ma*******@postg resql.org)
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, Shanmugasundara m 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 YourEmailAddres sHere" to ma*******@postg resql.org)
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, Shanmugasundara m 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
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, Shanmugasundara m 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
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, Shanmugasundara m 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, Shanmugasundara m 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 <mi**@thegodsha lls.com> writes: On Sat, 2004-06-19 at 13:12, Shanmugasundara m 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_timeou t 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: gigijk |
last post by:
Hi,
I have an application that causes a dead lock at random. The issue I am
having is, when the deadlock occurs, my applications is not recieving
any errors from the DB. ie, during the deadlock SQLServer is returning
an empty recordset and user is seeing a blank screen. The app logic
does not go into the Try Catch statment in the C# code. I can't
understand why my app is not receiveing 1205 error from SQL server when
dead lock occurs....
|
by: Rohit Raghuwanshi |
last post by:
Hello all,
we are running a delphi application with DB2 V8.01 which is causing
deadlocks when rows are being inserted into a table. Attaching the
Event Monitor Log (DEADLOCKS WITH DETAILS) here. From the log it looks
like the problem happens when 2 threads insert 1 record each in the
same table and then try to aquire a NS (Next Key Share)
lock on the record inserterd by the other thread.
Thanks
Rohit
|
by: Shanmugasundaram Doraisamy |
last post by:
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
|
by: dnphamus13 |
last post by:
I'm new to this and drowning right now. I would like to put my database
online for viewing. I managed to do the filtering but i need to do
PAGING as the XML doc get bigger. From what i understand this is what I
need to do; transform the current XML doc with the filterring xsl, then
somehow add the paging xsl. That's the part i'm having trouble with.
I'm using JavaScript to apply the filterring XSL to XML doc. Filterring
is based on what...
|
by: euan_woo |
last post by:
Hi,
Sometimes my program stops and when I break it I see 2 threads both
waiting at a lock statement trying to lock the same object. If I look
up the call stack of these threads there aren't any other calls to lock
statements so I don't see how it's possible for anything to be locked.
Can anyone explain this to me?
Thanks
| | |
by: ash |
last post by:
hi friends,
i have some questions whch is in my last year question papers.i need
some help to get logic of these questions.
1) write a C function, that takes two strings as arguments and returns
a pointer to the first occurrence of 1st string in 2nd string or NULL
if it is not present.
-- i tried to solve it but it seems that i am not understanding this
question at all.i am taking this question as:
|
by: misterutterbag |
last post by:
Hi.
Given the following:
----------------
String lockSubscriptionQuery =
"SELECT subscriptionId FROM subscription WHERE subscriptionId = ?
FOR UPDATE";
pStmt = conn.prepareStatement(lockSubscriptionQuery);
|
by: John Nagle |
last post by:
The major complaint I have about Python is that the packages
which connect it to other software components all seem to have
serious problems. As long as you don't need to talk to anything
outside the Python world, you're fine. But once you do, things
go downhill. MySQLdb has version and platform compatibility
problems. So does M2Crypto. The built-in SSL support is weak.
Even basic sockets don't quite work right; the socket module...
|
by: javabeginner123 |
last post by:
i have a java prob, and i have to solve it fast, but i'm just getting to know it, so plz help me solve it with full code completed, thanks so much. the prob is to create a monter fight and there is the description:
The monsters are of a very strange kind, called "Bigmon". They have some basic characteristics, like attack and defense power, life points, a name, and a bonus factor that is used in special occasions.
In this initial phase of the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
