| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com> |
| Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Deadlock situation? |
| Date: | 2008-04-29 22:33:59 |
| Message-ID: | 20080429223359.GO5652@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-30 01:46:15 | Re: Character Data Type 'Name' |
| Previous Message | Dan Armbrust | 2008-04-29 22:30:55 | Re: Deadlock situation? |