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