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

Re: Disk space taken

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Slavisa Garic <sgaric(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Disk space taken
Date: 2006-07-18 14:43:14
Message-ID: 20060718144314.12812.qmail@web31802.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> Running vacuumdb --full freed the rest of the disk space. Regarding indexes
> from what you said I understand that if I want to free the space used in the
> past by indexes and that isn't freed yet (but it should) I should run
> reindexdb (or reindex in SQL). I did that and another 300MB got freed so
> thank you for both hints,

Here is another link you might find useful.
http://linux.inet.hr/optimize_postgresql_database_size.html

I found it on this thread.  It is an interesting read.
http://archives.postgresql.org/pgsql-general/2006-06/msg00632.php

Regards,

Richard Broersma Jr.

In response to

pgsql-novice by date

Next:From: kmh496Date: 2006-07-18 14:50:51
Subject: why is scan not using index?
Previous:From: Slavisa GaricDate: 2006-07-18 12:55:39
Subject: Re: Disk space taken

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