Skip site navigation (1) Skip section navigation (2)

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

From: jose fuenmayor <jafn82(at)gmail(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>,jose fuenmayor <jafn82(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: size of indexes and tables (more than 1GB)
Date: 2005-08-30 12:38:03
Message-ID: 69f2062a050830053829b874c5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Bruno Wolff IIIDate: 2005-08-30 13:01:40
Subject: Re: size of indexes and tables (more than 1GB)
Previous:From: rohan rasaneDate: 2005-08-30 08:42:00
Subject: Unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group