Re: size of indexes and tables (more than 1GB) - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: size of indexes and tables (more than 1GB)
Date
Msg-id 20050825132334.GE15100@wolff.to
Whole thread Raw
In response to size of indexes and tables (more than 1GB)  (jose fuenmayor <jafn82@gmail.com>)
Responses Re: size of indexes and tables (more than 1GB)  (jose fuenmayor <jafn82@gmail.com>)
List pgsql-admin
On Thu, Aug 25, 2005 at 08:52:35 -0400,
  jose fuenmayor <jafn82@gmail.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.

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: How this query!
Next
From: "Kevin Keith"
Date:
Subject: Question regarding blocking locks