Re: [INTERFACES] table very big !!!!!

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: [INTERFACES] table very big !!!!!
Дата
Msg-id 383984DB.D8FE4C2D@tm.ee
обсуждение исходный текст
Ответ на table very big !!!!!  (Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>)
Список pgsql-interfaces
Pablo Salazar Loaiza wrote:
> 
> Hello all
> 
> I have a DB in Postgres, and i have one application that work with this
> DB, and exist one table where dialy is writing register in this table,
> but to midnigth , i do delete from table.
> 
> But the size always is growing.
>

You should run the database command 

>analyze;

that will get rid of old tuples that are no longer used

--------------
Hannu


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

Предыдущее
От: Pablo Salazar Loaiza
Дата:
Сообщение: table very big !!!!!
Следующее
От: "Rafal Piotrowski (CSCS)"
Дата:
Сообщение: problem with getBytes