Re: vacuum question
От | Kevin Kempter |
---|---|
Тема | Re: vacuum question |
Дата | |
Msg-id | 200908181441.47763.kevink@consistentstate.com обсуждение исходный текст |
Ответ на | Re: vacuum question (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: vacuum question
|
Список | pgsql-admin |
On Tuesday 18 August 2009 13:37:12 Tom Lane wrote: > Kevin Kempter <kevink@consistentstate.com> writes: > > INFO: "action_rollup_notifier": found 0 removable, 34391214 nonremovable > > row versions in 152175 pages > > DETAIL: 22424476 dead row versions cannot be removed yet. > > > > Anyone have any suggestions per why these rows cannot be removed yet? > > You've got an open transaction that's older than the one that deleted > those rows (or at least started before the latter committed). > pg_stat_activity might be helpful in fingering the culprit. > > regards, tom lane Does the use of serialized transactions affect this in any way?
В списке pgsql-admin по дате отправления: