Re: pg_class table problem

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: pg_class table problem
Дата
Msg-id 20040317224918.GA18987@svana.org
обсуждение исходный текст
Ответ на pg_class table problem  (Shilong Stanley Yao <yao@noao.edu>)
Список pgsql-general
On Wed, Mar 17, 2004 at 03:29:33PM -0700, Shilong Stanley Yao wrote:
> Hi,
> I inserted thousands of records in a table, but when using "select
> relname, relpages from pg_class;", the number of pages of the table in
> which I am inserting records is always 10, which is the same as an empty
> table.  Am I doing anything wrong? Thanks, -Stan

These figures are updated by VACUUM and possibly by ANALYZE also.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

Вложения

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

Предыдущее
От: Shilong Stanley Yao
Дата:
Сообщение: pg_class table problem
Следующее
От: Shilong Stanley Yao
Дата:
Сообщение: Re: pg_class table problem