Title: database & table size
Hi,
Have you tried to run 'VACUUM FULL' command?
According to PostgreSQL documentation
-8<---
8.2.1. Recovering disk space
In normal PostgreSQL operation, an UPDATE or DELETE of a row does not
immediately remove the old tuple (ver
On Wed, 25 Jun 2003, Anagha Joshi wrote:
> 4. the file '2078989' corresponds to 'cdrrec' file (table)
>
> $ ls -l 2078989
> -rw--- 1 postgres postgres 2359296 Jun 24 17:18 2078989
>
> This means table 'cdrrec' takes approx. 2030.2626953125 KB i.e. approx.
> 2MB
>
> Table is like