Re: Table space grow big - PostgreSQL

On Wed, 2010-05-05 at 13:36 +0200, Khangelani Gama wrote:
> The main question I have is: What makes
> the /usr/local/pgsql/data/base/95186722/ grow so big while the actual
> data with its schema is only 2.8G and that is there a way to reduce
> the table space sizes or anything related to that?

Which PostgreSQL version is this? I'm assuming it is an old one, since
you are running Red Hat 9.

Have you vacuumed it recently/regularly? If not, dead space (space that
is consumed by dead tuples) will consume lots of disk space, until they
are vacuumed. However, If you haven't vacuumed for a long time, it may
be the best to dump/restore the database, and then apply regular
maintenance:

http://www.postgresql.org/docs/current/static/maintenance.html

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz