2009/6/27 Scott Carey <sc...@richrelevance.com>: > In addition to the above, note that long lived transactions cause all sorts > of other problems in the database. In particular, table and index bloat can > become severe due to this sort of poor client behavior if there is a lot of > update or delete activity. You can find out with "vacuum analyze verbose" > on tables of interest whether there are a high ratio of dead tuples in the > tables and indexes.
Yes indeed... by the by, I understand Alvaro Herrera has improved this situation considerably for the forthcoming 8.4 release. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
