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.
In response to
pgsql-admin by date
|Next:||From: Bruno Wolff III||Date: 2005-08-30 13:01:40|
|Subject: Re: size of indexes and tables (more than 1GB)|
|Previous:||From: rohan rasane||Date: 2005-08-30 08:42:00|