Re: [SQL] database & table size

2003-06-24 Thread Frankie Lam
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

Re: [SQL] database & table size

2003-06-24 Thread Stephan Szabo
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