Re: row-attribute in EXPLAIN-output doesn't match count(*)

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: row-attribute in EXPLAIN-output doesn't match count(*)
Дата
Msg-id 20050414173358.GB9027@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: row-attribute in EXPLAIN-output doesn't match count(*)  (Andreas Joseph Krogh <andreak@officenet.no>)
Ответы Re: row-attribute in EXPLAIN-output doesn't match count(*)  (Andreas Joseph Krogh <andreak@officenet.no>)
Re: row-attribute in EXPLAIN-output doesn't match count(*)  (Greg Stark <gsstark@mit.edu>)
Список pgsql-sql
Дерево обсуждения 
On Thu, Apr 14, 2005 at 07:21:38PM +0200, Andreas Joseph Krogh wrote:
> 
> So, what you're suggesting is that a restart of the webapp should make vacuum 
> able to delete those dead rows?

Yes, but that'll only solve your problem for now.  You'll have the
problem again soon.  What's keeping open the transaction?

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.    --Philip Greenspun

В списке pgsql-sql по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: row-attribute in EXPLAIN-output doesn't match count(*)
Следующее
От: "Moran.Michael"
Дата:
Сообщение: Re: PGCrypto: Realworld scenario and advice needed