2009/6/27 Scott Carey <scott(at)richrelevance(dot)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.
In response to
pgsql-performance by date
|Next:||From: Alan McKay||Date: 2009-06-28 13:52:24|
|Subject: Re: what server stats to track / monitor ?|
|Previous:||From: Greg Smith||Date: 2009-06-27 05:08:17|
|Subject: Re: Insert performance and multi-column index order|