questions on toast tables

Поиск
Список
Период
Сортировка
От Warren Little
Тема questions on toast tables
Дата
Msg-id 1146240597.9528.17.camel@wlittle.meridias.local
обсуждение исходный текст
Ответы Re: questions on toast tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
I have a toast table that is referenced by a single user table define
below:

CREATE TABLE casedocument
(
  pid varchar(12) NOT NULL,
  createdt timestamp NOT NULL,
  descr varchar(40),
  docformat varchar(10) NOT NULL,
  version int4 NOT NULL,
  casepid varchar(12) NOT NULL,
  createuserpid varchar(12) NOT NULL,
  typepid varchar(12) NOT NULL,
  sent bool DEFAULT false,
  active bool DEFAULT true,
  auxpid varchar(12),
  CONSTRAINT copycasedoc_pkey PRIMARY KEY (pid)
)
WITH OIDS;


There are 40k rows in the user table
The toast table contains 5781417 pages

Something does not seem right here.


1) should the user table even be relying on a toast table

2) the 40k rows and data sizes do not seem to equal the number of pages
in the related toast table.

3) I know that once upon a time the table had a bytea column, but that
was dropped.  Do I need to do a full vacuum on that table to get rid of
the related toast data?

thanks




--
Warren Little
Chief Technology Officer
Meridias Capital Inc
1018 W Atherton Dr
Salt Lake City, UT 84123
ph: 866.369.7763

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

Предыдущее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: New system recommendations
Следующее
От: Robin Iddon
Дата:
Сообщение: Re: Backing up large databases