Re: size of indexes and tables (more than 1GB)

i am using postgreSql 8.0.3 i've try vacuum "vacuum full" the hole database
but it takes too long, seems it will never be finished, i've tried "vacuum
<table_name>" and the table remains nearly the same as isee i my PGDATA
directory. is this normal? . is there something i can do ?

On 8/25/05, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
>
> On Thu, Aug 25, 2005 at 08:52:35 -0400,
> jose fuenmayor <jafn82(at)gmail(dot)com> wrote:
> >
> > The size of the table is 3 times bigger than, for instance Visual Fox
> > Pro dbf's? since is there fisically three times.
>
> Have you been vacuuming properly? It is possible you have a lot of dead
> tuples in the database. If that seems to be the case and you need more
> help dealing with this, please include the version of Postgres you are
> running, since that will affect what suggestions people will give you.
>