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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: jose fuenmayor <jafn82(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: size of indexes and tables (more than 1GB)
Date: 2005-08-25 13:23:34
Message-ID: 20050825132334.GE15100@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Keith 2005-08-25 14:28:13 Question regarding blocking locks
Previous Message Bruno Wolff III 2005-08-25 13:19:58 Re: How this query!