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

[jose fuenmayor <jafn82@xxxxxxxxx>]

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@xxxxxxxx> wrote:

On Thu, Aug 25, 2005 at 08:52:35 -0400,
  jose fuenmayor <jafn82@xxxxxxxxx> 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.