Re: count(*) performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: count(*) performance
Дата
Msg-id 24743.1143501228@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: count(*) performance  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-performance
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> It is fairly easy to implement, however it has been discussed before and
> decided that it wasn't necessary.  What the system cares about is how
> long it's been since the last vacuum in terms of XIDs not time.

I think Alvaro is intending to do the latter (store per-table vacuum xid
info) for 8.2.

            regards, tom lane

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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: count(*) performance
Следующее
От: "Mikael Carneholm"
Дата:
Сообщение: Re: count(*) performance