Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Deadlock si...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 11 Topic 15422 of 17602
 Post > Topic >>

Re: Deadlock situation?

by alvherre@[EMAIL PROTECTED] (Alvaro Herrera) Apr 29, 2008 at 06:33 PM

Dan Armbrust escribió:

> select * from pg_stat_activity;" shows me that most of my connections
> in a COMMIT phase:
> 
> 03:05:37.73064-05  | 2008-04-24 03:05:38.419796-05 | 2008-04-24
> 02:11:53.908518-05 | 127.0.0.1   |       53807
>  16385 | ispaaa  |     953 |    16384 | pslogin  | COMMIT       | f
>    | 2008-04-24

Do you have deferred constraints?  Maybe some of them are missing
indexes.

-- 
Alvaro Herrera                               
http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 sup****t

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




 11 Posts in Topic:
Deadlock situation?
 daniel.armbrust.list@[EMA  2008-04-29 16:54:48 
Re: Deadlock situation?
 erik@[EMAIL PROTECTED] (  2008-04-29 17:10:31 
Re: Deadlock situation?
 daniel.armbrust.list@[EMA  2008-04-29 17:30:55 
Re: Deadlock situation?
 tgl@[EMAIL PROTECTED] (T  2008-04-29 22:20:06 
Re: Deadlock situation?
 alvherre@[EMAIL PROTECTED  2008-04-29 18:33:59 
Re: Deadlock situation?
 daniel.armbrust.list@[EMA  2008-04-30 09:55:25 
Re: Deadlock situation?
 tgl@[EMAIL PROTECTED] (T  2008-04-30 11:33:35 
Re: Deadlock situation?
 daniel.armbrust.list@[EMA  2008-04-30 11:17:23 
Re: Deadlock situation?
 dan@[EMAIL PROTECTED]   2008-04-30 13:36:15 
Re: Deadlock situation?
 daniel.armbrust.list@[EMA  2008-05-01 10:38:46 
Re: Deadlock situation?
 scott.marlowe@[EMAIL PROT  2008-05-01 10:44:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan12V112 Mon Dec 1 19:06:04 CST 2008.