Number of tuples in pg_class - bug or misunderstanding?

Поиск
Список
Период
Сортировка
От Martin Neumann
Тема Number of tuples in pg_class - bug or misunderstanding?
Дата
Msg-id 87wvl1zf60.fsf@darwin.mne.de
обсуждение исходный текст
Ответы Re: Number of tuples in pg_class - bug or misunderstanding?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
I'm just digging a little bit in PostgreSQL internals and I found the
following thing. Shouldn't the reltuples field in pg_class contain the
real number of tuples? It is always a little bit to low ...

irc=# SELECT reltuples FROM pg_class WHERE relname = 'events';
 reltuples
-----------
       188
(1 row)

irc=# SELECT COUNT(*) FROM events;
 count
-------
   195
(1 row)


This annoys me a little bit as I can do
  SELECT reltuples FROM pg_class WHERE relname = $1;
from plpgsql, but not
  SELECT COUNT(*) FROM $1;
--
Martin Neumann
Appartement 201, Emil-Figge-Str. 9, 44227 Dortmund, Germany
mne@mne.de - http://www.mne.de/ - PGP key @ http://www.mne.de/mne/pgp.txt

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

Предыдущее
От: Vashenko Maxim
Дата:
Сообщение: index problem ? (core dumped)
Следующее
От: Denis Sbragion
Дата:
Сообщение: Small bug with numeric in 7.0 (also in 6.5.3)