Does it has a way to compact the database size?

Поиск
Список
Период
Сортировка
От Premsun Choltanwanich
Тема Does it has a way to compact the database size?
Дата
Msg-id 45ED886E.C5F7.004C.0@nsasia.co.th
обсуждение исходный текст
Ответы Re: Does it has a way to compact the database size?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Does it has a way to compact the database size?  (Richard Huxton <dev@archonet.com>)
Re: Does it has a way to compact the database size?  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-general
Dear All,
 
I use PostgreSQL 8.0.3 for store my data started on Sep'06. Today, I use database_size('name') function for checking my database size and found that it's about 1209715345.
 
I think that something maybe wrong on my database because I backup my database everyday and the backup size is about 10 MB.  So I restore databse from my backup file then use database_size('name') function again and found that  database size is about 56642193.
 
I can said both 1209715345 and 56642193 are coming from the same database but I wonder that why it quiet difference on size.
 
Any Idea?
And How can I control or compact my database size for make it smallest as possibled?

NETsolutions Asia Limited

+66 (2) 237 7247

NETsolutions Asia Limited

Вложения

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

Предыдущее
От: veejar
Дата:
Сообщение: FreeBSD kernel configuration
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Does it has a way to compact the database size?